V$SESSION
版本:Oracle 11g
显示每个当前会话的会话信息。
|
|
|
|
|
| Session address | 会议地址 |
|
| Session identifier | 会话标识符 |
|
| Session serial number. Used to uniquely identify a session's objects. Guarantees that session-level commands are applied to the correct session objects if the session ends and another session begins with the same session ID. | 会话序列号。用于唯一标识会话的对象。如果会话结束并且另一个会话以相同的会话ID开头,则确保将会话级命令应用于正确的会话对象。 |
|
| Auditing session ID | 审核会话ID |
|
| Address of the process that owns the session | 拥有会话的进程的地址 |
|
| Oracle user identifier | Oracle用户标识 |
|
| Oracle username | Oracle用户名 |
|
| Command in progress (last statement parsed). You can find the command name for any value n returned in this
A value of | 命令正在执行(已解析最后一条语句)。 通过运行以下SQL查询,可以找到此列中返回的任何值n的命令名称
|
|
| Identifier of the user who owns the migratable session; the column contents are invalid if the value is For operations using Parallel Slaves, interpret this value as a 4-byte value. The low-order 2 bytes represent the session number and the high-order bytes represent the instance ID of the query coordinator. | 拥有可迁移会话的用户的标识符;如果值为,则列内容无效 对于使用并行从设备的操作,将此值解释为4字节的值。低位2个字节代表会话号,高位2个字节代表查询协调器的实例ID。 |
|
| Address of the transaction state object | 交易状态对象的地址 |
|
| Address of the lock the session is waiting for; NULL if none | 会话正在等待的锁的地址;如果没有则为NULL |
|
| Status of the session:
| 会话状态:
|
|
| Server type:
| 服务器类型:
|
|
| Schema user identifier | 模式用户标识符 |
|
| Schema user name | 模式用户名 |
|
| Operating system client user name | 操作系统客户端用户名 |
|
| Operating system client process ID | 操作系统客户端进程ID |
|
| Operating system machine name | 操作系统机器名称 |
|
| Client port number | 客户端端口号 |
|
| Operating system terminal name | 操作系统终端名称 |
|
| Operating system program name | 操作系统程序名称 |
|
| Session type | 会话类型 |
|
| Used with | 用于 |
|
| Used with | 用于 |
|
| SQL identifier of the SQL statement that is currently being executed | 当前正在执行的SQL语句的SQL标识符 |
|
| Child number of the SQL statement that is currently being executed | 当前正在执行的SQL语句的子代号 |
|
| Time when the execution of the SQL currently executed by this session started; NULL if | 开始由该会话当前执行的SQL的执行时间;如果 |
|
| SQL execution identifier; NULL if | SQL执行标识符;如果 |
|
| Used with | 用于 |
|
| Used with | 用于 |
|
| SQL identifier of the last SQL statement executed | 最后执行的SQL语句的SQL标识符 |
|
| Child number of the last SQL statement executed | 最后执行的SQL语句的子编号 |
|
| SQL execution start of the last executed SQL statement | 最后执行的SQL语句的SQL执行开始 |
|
| SQL execution identifier of the last executed SQL statement | 最后执行的SQL语句的SQL执行标识符 |
|
| Object ID of the top-most PL/SQL subprogram on the stack; NULL if there is no PL/SQL subprogram on the stack | 堆栈上最顶层的PL / SQL子程序的对象ID;如果堆栈上没有PL / SQL子程序,则为NULL |
|
| Subprogram ID of the top-most PL/SQL subprogram on the stack; NULL if there is no PL/SQL subprogram on the stack | 堆栈中最顶层的PL / SQL子程序的子程序ID;如果堆栈上没有PL / SQL子程序,则为NULL |
|
| Object ID of the currently executing PL/SQL subprogram; NULL if executing SQL | 当前正在执行的PL / SQL子程序的对象ID;如果执行SQL,则为NULL |
|
| Subprogram ID of the currently executing PL/SQL object; NULL if executing SQL | 当前正在执行的PL / SQL对象的子程序ID;如果执行SQL,则为NULL |
|
| Name of the currently executing module as set by calling the | 通过调用 |
|
| Hash value of the |
|
|
| Name of the currently executing action as set by calling the | 通过调用 |
|
| Hash value of the |
|
|
| Information set by the |
|
|
| This contains a number that increases every time the session completes a call to the database and there has been an intervening select from a dynamic performance table. This column can be used by performance monitors to monitor statistics in the database. Each time the performance monitor looks at the database, it only needs to look at sessions that are currently active or have a higher value in this column than the highest value that the performance monitor saw the last time. All the other sessions have been idle since the last time the performance monitor looked at the database. | 每次会话完成对数据库的调用并且动态性能表中存在中间选择时,此数字都会增加。性能监视器可以使用此列来监视数据库中的统计信息。每次性能监视器查看数据库时,它只需要查看当前处于活动状态的会话或该列中的值大于性能监视器上次看到的最大值的会话。自性能监视器上次查看数据库以来,所有其他会话一直处于空闲状态。 |
|
| Object ID for the table containing the row specified in | 包含在中指定的行的表的对象ID |
|
| Identifier for the datafile containing the row specified in | 包含中指定行的数据文件的标识符 |
|
| Identifier for the block containing the row specified in | 包含中指定行的块的标识符 |
|
| Current row being locked. This column is valid only if the session is currently waiting for another transaction to commit and the value of | 当前行被锁定。仅当会话当前正在等待另一个事务提交且的值 |
|
| Oracle top level call number | Oracle顶级电话号码 |
|
| Time of logon | 登录时间 |
|
| If the session If the session | 如果会话 如果会话 |
|
| This column has been replaced by the | 此列已被替换为 |
|
| Indicates whether and to what extent transparent application failover (TAF) is enabled for the session:
See Also:
| 指示是否为会话启用透明应用程序故障转移(TAF),以及在何种程度上启用了透明应用程序故障转移(TAF):
也可以看看:
|
|
| Indicates the transparent application failover method for the session:
| 指示会话的透明应用程序故障转移方法:
|
|
| Indicates whether the session is running in failover mode and failover has occurred ( | 指示会话是否以故障转移模式运行,并且是否已发生故障转移 |
|
| Name of the session's current resource consumer group | 会话当前资源使用者组的名称 |
|
| If | 如果为 |
|
| If | 如果为 |
|
| If | 如果为 |
|
| If queued ( | 如果已排队( |
|
| Client identifier of the session | 会话的客户端标识符 |
|
| This column provides details on whether there is a blocking session:
| 此列提供有关是否存在阻止会话的详细信息:
|
|
| Instance identifier of the blocking session. This column is valid only if | 阻止会话的实例标识符。只有 |
|
| Session identifier of the blocking session. This column is valid only if | 阻止会话的会话标识符。只有 |
|
| The final blocking session is the final element in the wait chain constructed by following the sessions that are blocked by one another starting with this session. In the case of a cyclical wait chain, one of the sessions in the wait chain will be chosen as the final blocker. This column provides details on whether there is a final blocking session:
| 最终阻止会话是等待链中的最后一个元素,该等待链是通过从此会话开始彼此跟踪被阻止的会话而构建的。对于周期性等待链,将选择等待链中的会话之一作为最终阻止者。 此列提供有关是否存在最终阻止会话的详细信息:
|
|
| Instance identifier of the final blocking session. This column is valid only if | 最终阻止会话的实例标识符。只有 |
|
| Session identifier of the blocking session. This column is valid only if | 阻止会话的会话标识符。只有 |
|
| A number that uniquely identifies the current or last wait (incremented for each wait) | 一个唯一标识当前或上一次等待的数字(每次等待增加) |
|
| Event number | 活动编号 |
|
| Resource or event for which the session is waiting See Also: Appendix C, "Oracle Wait Events" | 会话正在等待的资源或事件 另请参见: 附录C,“ Oracle等待事件” |
|
| Description of the first wait event parameter | 第一个等待事件参数的描述 |
|
| First wait event parameter (in decimal) | 首次等待事件参数(十进制) |
|
| First wait event parameter (in hexadecimal)Foot 2 | 首次等待事件参数(以十六进制表示)Foot 2 |
|
| Description of the second wait event parameter | 第二个等待事件参数的描述 |
|
| Second wait event parameter (in decimal) | 第二个等待事件参数(十进制) |
|
| Second wait event parameter (in hexadecimal)Footref 2 | 第二个等待事件参数(十六进制)Footref 2 |
|
| Description of the third wait event parameter | 第三个等待事件参数的描述 |
|
| Third wait event parameter (in decimal) | 第三个等待事件参数(十进制) |
|
| Third wait event parameter (in hexadecimal)Footref 2 | 第三个等待事件参数(以十六进制表示)Footref 2 |
|
| Identifier of the class of the wait event | 等待事件的类别的标识符 |
|
| Number of the class of the wait event | 等待事件的类别编号 |
|
| Name of the class of the wait event | 等待事件的类的名称 |
|
| If the session is currently waiting, then the value is
This column has been deprecated in favor of the columns | 如果会话当前正在等待,则值为
不推荐使用此列,而推荐使用列 |
|
| If the session is currently waiting, then the value is the amount of time waited for the current wait. If the session is not in a wait, then the value is the amount of time since the start of the last wait. This column has been deprecated in favor of the columns | 如果会话当前正在等待,则该值为等待当前等待的时间。如果会话不在等待中,则该值为自上次等待开始以来的时间。 不推荐使用此列,而推荐使用列 |
|
| Wait state:
| 等待状态:
|
|
| Amount of time waited (in microseconds). If the session is currently waiting, then the value is the time spent in the current wait. If the session is currently not in a wait, then the value is the amount of time waited in the last wait. | 等待的时间(以微秒为单位)。如果会话当前正在等待,则该值为当前等待中花费的时间。如果会话当前不在等待中,则该值为上一次等待中等待的时间。 |
|
| Value is interpreted as follows:
| 值解释如下:
|
|
| Time elapsed since the end of the last wait (in microseconds). If the session is currently in a wait, then the value is | 自上次等待结束以来经过的时间(以微秒为单位)。如果会话当前正在等待,则值为 |
|
| Service name of the session | 会话的服务名称 |
|
| Indicates whether SQL tracing is enabled ( | 指示是启用( |
|
| Indicates whether wait tracing is enabled ( | 指示是否启用等待跟踪( |
|
| Indicates whether bind tracing is enabled ( | 指示绑定跟踪是否被启用( |
|
| Frequency at which row source statistics are dumped in the trace files for each cursor:
| 每个游标在跟踪文件中转储行源统计信息的频率:
|
|
| Shows the value that, in the session, would be reported by | 显示在会话中将由以下人员报告的值 |
|
| Address of the creating process or circuit | 创建过程或电路的地址 |
|
| Serial number of the creating process or circuit | 创建过程或电路的序列号 |
|
| Execution context identifier (sent by Application Server) | 执行上下文标识符(由Application Server发送) |