ITPub博客

首页 > Linux操作系统 > Linux操作系统 > session与transaction的区别

session与transaction的区别

原创 Linux操作系统 作者:tonywi888 时间:2008-03-18 09:27:36 0 删除 编辑

session:用户对数据库的连接

A session is a specific connection of a user to an Oracle instance through a user process. For example, when a user starts SQL*Plus, the user must provide a valid username and password, and then a session is established for that user. A session lasts from the time the user connects until the time the user disconnects or exits the database application.

transaction:简单的说就是从开始或上一次commit起,到这次commit为止,当然有些命令是隐含commit的。

A transaction is a logical unit of work that comprises one or more SQL statements executed by a single user. According to the ANSI/ISO SQL standard, with which Oracle is compatible, a transaction begins with the user’s first executable SQL statement. A transaction ends when it is explicitly committed or rolled back by that user.

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/8570952/viewspace-209638/ ,如需转载,请注明出处,否则将追究法律责任。

下一篇: 创建DB_LINK
请登录后发表评论 登录
全部评论

注册时间:2008-02-25

  • 博文量
    159
  • 访问量
    736775