【会话】V$SESSION视图

比眉伴天荒 2022-01-31 07:29 332阅读 0赞

# 【会话】V$SESSION视图 #

--------------------

讲到Oracle的会话，就必须首先对V$SESSION这个视图中的每个列都非常熟悉。该视图在Oracle 11gR2下包含97列，在Oracle 12cR2下增加了6列，共包含103列。下面作者以表格的形式对这个视图中的重要列做详细说明。

表 3-26 V$SESSION视图

<table style="border-color:#000000;border-collapse:collapse;font-family:'courier new';"> 
 <tbody> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 <td colspan="4" style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> V$SESSION&nbsp;displays&nbsp;session&nbsp;information&nbsp;for&nbsp;each&nbsp;current&nbsp;session. </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 视图列序号 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;font-weight:700;vertical-align:middle;background:#E7E6E6;"> 列 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;font-weight:700;text-align:center;vertical-align:middle;background:#E7E6E6;"> 数据类型 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;font-weight:700;vertical-align:middle;background:#E7E6E6;"> 说明 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;font-weight:700;vertical-align:middle;background:#E7E6E6;"> 官方解释 </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 备注 </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 1 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> SADDR </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> RAW(4&nbsp;|&nbsp;8) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 会话地址，对应于V$TRANSACTION.SES_ADDR列。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Session&nbsp;address </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 2 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> SID </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 会话标识符。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Session&nbsp;identifier </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 3 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> SERIAL# </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 会话序列号，用来唯一地标识会话对象。如果该会话结束且其它会话以相同的会话ID开始，那么可以保证会话级的命令被应用到正确的会话对象。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Session&nbsp;serial&nbsp;number.&nbsp;Used&nbsp;to&nbsp;uniquely&nbsp;identify&nbsp;a&nbsp;session's&nbsp;objects.&nbsp;Guarantees&nbsp;that&nbsp;session-level&nbsp;commands&nbsp;are&nbsp;applied&nbsp;to&nbsp;the&nbsp;correct&nbsp;session&nbsp;objects&nbsp;if&nbsp;the&nbsp;session&nbsp;ends&nbsp;and&nbsp;another&nbsp;session&nbsp;begins&nbsp;with&nbsp;the&nbsp;same&nbsp;session&nbsp;ID. </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 4 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> AUDSID </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 审计会话ID，审查SESSION&nbsp;ID的唯一性，通常也用于寻找并行查询模式。 SELECT&nbsp;SID, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;OSUSER, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;USERNAME, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MACHINE, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;PROCESS&nbsp; FROM&nbsp;&nbsp;&nbsp;V$SESSION WHERE&nbsp;&nbsp;AUDSID&nbsp;=&nbsp;USERENV('SESSIONID'); SELECT&nbsp;USERENV('LANGUAGE')&nbsp;数据库字符集, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;USERENV('ISDBA')&nbsp;是否DBA角色, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;USERENV('SESSIONID')&nbsp;当前会话标识符, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;USERENV('ENTRYID')&nbsp;可审计的会话标识符, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;USERENV('LANG')&nbsp;会话语言名称的ISO简记, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;USERENV('INSTANCE')&nbsp;当前的实例, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;USERENV('TERMINAL')&nbsp;当前计算机名 &nbsp;FROM&nbsp;&nbsp;&nbsp;DUAL; </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Auditing&nbsp;session&nbsp;ID </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 5 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> PADDR </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> RAW(4&nbsp;|&nbsp;8) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 拥有这个会话的进程地址，对应于V$PROCESS.ADDR列，通常用于查询会话对应的OS进程号： SELECT&nbsp;B.SID,&nbsp;B.SERIAL#,&nbsp;C.SPID &nbsp;&nbsp;FROM&nbsp;V$SESSION&nbsp;B,&nbsp;V$PROCESS&nbsp;C &nbsp;WHERE&nbsp;B.PADDR&nbsp;=&nbsp;C.ADDR; </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Address&nbsp;of&nbsp;the&nbsp;process&nbsp;that&nbsp;owns&nbsp;the&nbsp;session </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 6 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> USER# </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Oracle用户标识符。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Oracle&nbsp;user&nbsp;identifier </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 7 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> USERNAME </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> VARCHAR2(30) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Oracle用户名。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Oracle&nbsp;username </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 8 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> COMMAND </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 正在执行的SQL语句类型（分析的最后一个语句）。关于该列值的含义，请参阅V$SQLCOMMAND.COMMAND列。如果该列的值为0，那么表示并没有在V$SESSION视图里记录。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Command&nbsp;in&nbsp;progress&nbsp;(last&nbsp;statement&nbsp;parsed). You&nbsp;can&nbsp;find&nbsp;the&nbsp;command&nbsp;name&nbsp;for&nbsp;any&nbsp;value&nbsp;n&nbsp;returned&nbsp;in&nbsp;this&nbsp;COMMAND&nbsp;column&nbsp;by&nbsp;running&nbsp;this&nbsp;SQL&nbsp;query: SELECT&nbsp;command_name &nbsp;&nbsp;&nbsp;FROM&nbsp;v$sqlcommand &nbsp;&nbsp;&nbsp;WHERE&nbsp;command_type&nbsp;=&nbsp;n; A&nbsp;value&nbsp;of&nbsp;0&nbsp;in&nbsp;this&nbsp;COMMAND&nbsp;column&nbsp;means&nbsp;the&nbsp;command&nbsp;is&nbsp;not&nbsp;recorded&nbsp;in&nbsp;V$SESSION. </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> sys.audit_actions </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 9 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> OWNERID </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 如果值为2147483644，那么此列的内容无效,否则此列包含拥有可移植会话的用户标符。对于利用并行从服务器的操作，将这个值解释为一个4字节的值，其低位两字节表示会话号，而高位字节表示查询协调程序的实例ID。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Identifier&nbsp;of&nbsp;the&nbsp;user&nbsp;who&nbsp;owns&nbsp;the&nbsp;migratable&nbsp;session;&nbsp;the&nbsp;column&nbsp;contents&nbsp;are&nbsp;invalid&nbsp;if&nbsp;the&nbsp;value&nbsp;is&nbsp;2147483644 For&nbsp;operations&nbsp;using&nbsp;Parallel&nbsp;Slaves,&nbsp;interpret&nbsp;this&nbsp;value&nbsp;as&nbsp;a&nbsp;4-byte&nbsp;value.&nbsp;The&nbsp;low-order&nbsp;2&nbsp;bytes&nbsp;represent&nbsp;the&nbsp;session&nbsp;number&nbsp;and&nbsp;the&nbsp;high-order&nbsp;bytes&nbsp;represent&nbsp;the&nbsp;instance&nbsp;ID&nbsp;of&nbsp;the&nbsp;query&nbsp;coordinator. </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 10 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> TADDR </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> VARCHAR2(8) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 表示事务处理状态对象的地址，对应于V$TRANSACTION.ADDR列。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Address&nbsp;of&nbsp;the&nbsp;transaction&nbsp;state&nbsp;object </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 11 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> LOCKWAIT </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> VARCHAR2(8) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 等待锁的地址，对应于V$LOCK的KADDR列；若当前会话没有被阻塞则为空 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Address&nbsp;of&nbsp;the&nbsp;lock&nbsp;the&nbsp;session&nbsp;is&nbsp;waiting&nbsp;for;&nbsp;NULL&nbsp;if&nbsp;none </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 12 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> STATUS </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> VARCHAR2(8) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 会话的状态： ?ACTIVE：当前正在执行SQL语句（waiting&nbsp;for/using&nbsp;a&nbsp;resource）； ?INACTIVE：等待操作（即等待需要执行的SQL语句）； ?KILLED：标记为终止，删除； ?CACHED：为Oracle*XA使用而临时高速缓存； ?SNIPED：会话不活动，在客户机上等待，该状态不再被允许变为ACTIVE。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Status&nbsp;of&nbsp;the&nbsp;session: ACTIVE&nbsp;-&nbsp;Session&nbsp;currently&nbsp;executing&nbsp;SQL INACTIVE&nbsp;-&nbsp;Session&nbsp;which&nbsp;is&nbsp;inactive&nbsp;and&nbsp;either&nbsp;has&nbsp;no&nbsp;configured&nbsp;limits&nbsp;or&nbsp;has&nbsp;not&nbsp;yet&nbsp;exceeded&nbsp;the&nbsp;configured&nbsp;limits KILLED&nbsp;-&nbsp;Session&nbsp;marked&nbsp;to&nbsp;be&nbsp;killed CACHED&nbsp;-&nbsp;Session&nbsp;temporarily&nbsp;cached&nbsp;for&nbsp;use&nbsp;by&nbsp;Oracle*XA SNIPED&nbsp;-&nbsp;An&nbsp;inactive&nbsp;session&nbsp;that&nbsp;has&nbsp;exceeded&nbsp;some&nbsp;configured&nbsp;limits&nbsp;(for&nbsp;example,&nbsp;resource&nbsp;limits&nbsp;specified&nbsp;for&nbsp;the&nbsp;resource&nbsp;manager&nbsp;consumer&nbsp;group&nbsp;or&nbsp;idle_time&nbsp;specified&nbsp;in&nbsp;the&nbsp;user's&nbsp;profile).&nbsp;Such&nbsp;sessions&nbsp;will&nbsp;not&nbsp;be&nbsp;allowed&nbsp;to&nbsp;become&nbsp;active&nbsp;again. </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 13 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> SERVER </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> VARCHAR2(9) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 表示服务器类型：DEDICATED、SHARED、PSEUDO、POOLED、NONE。若显示的结果中有NONE或SHARED，则说明当前数据库启动了共享服务器模式。其中，状态为NONE的会话表示空闲的共享服务器连接，说明当前会话没有处理任务；若进程正在执行某些任务则会表现为SHARED状态。PSEUDO和“ALTER&nbsp;SYSTEM&nbsp;KILL&nbsp;SESSION&nbsp;sid,serial#;”相关，如果发出ALTER&nbsp;SYSTEM去终止一个会话，被标记为终止的SESSION在V$SEESSION的STATUS为KILLED，对应的SERVER值为PSEUDO。POOLED和Oracle&nbsp;11g推出的驻留连接池（Database&nbsp;Resident&nbsp;Connection&nbsp;Pool）特性相关，驻留连接池提供了数据库层面上的连接池管理机制，为应对高并发、短会话前端应用进行有益的尝试，POOLED表示使用驻留连接池技术的连接。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Server&nbsp;type:&nbsp; ?DEDICATED ?SHARED ?PSEUDO ?POOLED ?NONE </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 14 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> SCHEMA# </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 模式用户标识符。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Schema&nbsp;user&nbsp;identifier </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 15 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> SCHEMANAME </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> VARCHAR2(30) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 模式用户名。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Schema&nbsp;user&nbsp;name </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 16 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> OSUSER </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> VARCHAR2(30) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 操作系统客户端用户名。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Operating&nbsp;system&nbsp;client&nbsp;user&nbsp;name </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 17 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> PROCESS </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> VARCHAR2(24) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 操作系统的客户端进程ID，即客户端进程在客户端机器上的进程ID号；V$PROCESS中的SPID表示的是操作系统的进程ID，即服务器进程在服务器上的进程ID。若客户端为Windows系统，则该列的值格式为“客户端进程ID:线程ID”。对于后台进程而言（TYPE='BACKGROUND'），该列的值和V$PROCESS中的SPID的值是一致的。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Operating&nbsp;system&nbsp;client&nbsp;process&nbsp;ID </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 18 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> MACHINE </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> VARCHAR2(64) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 操作系统机器名。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Operating&nbsp;system&nbsp;machine&nbsp;name </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 19 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> PORT </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 客户端端口号。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Client&nbsp;port&nbsp;number </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 20 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> TERMINAL </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> VARCHAR2(30) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 操作系统终端名。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Operating&nbsp;system&nbsp;terminal&nbsp;name </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 21 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> PROGRAM </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> VARCHAR2(48) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 操作系统程序名。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Operating&nbsp;system&nbsp;program&nbsp;name </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 22 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> TYPE </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> VARCHAR2(10) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 会话类型，BACKGROUND表示后台进程，USER表示用户进程。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Session&nbsp;type </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 23 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> SQL_ADDRESS </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> RAW(4&nbsp;|&nbsp;8) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 与SQL_HASH_VALUE一道使用标识当前正在执行的SQL语句。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Used&nbsp;with&nbsp;SQL_HASH_VALUE&nbsp;to&nbsp;identify&nbsp;the&nbsp;SQL&nbsp;statement&nbsp;that&nbsp;is&nbsp;currently&nbsp;being&nbsp;executed </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 24 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> SQL_HASH_VALUE </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 与SQL_ADDRESS一道使用标识当前正在执行的SQL语句。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Used&nbsp;with&nbsp;SQL_ADDRESS&nbsp;to&nbsp;identify&nbsp;the&nbsp;SQL&nbsp;statement&nbsp;that&nbsp;is&nbsp;currently&nbsp;being&nbsp;executed </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 25 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> SQL_ID </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> VARCHAR2(13) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 正在执行的SQL语句ID </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> SQL&nbsp;identifier&nbsp;of&nbsp;the&nbsp;SQL&nbsp;statement&nbsp;that&nbsp;is&nbsp;currently&nbsp;being&nbsp;executed </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 26 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> SQL_CHILD_NUMBER </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 正在执行的SQL语句的子游标的ID，从0开始 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Child&nbsp;number&nbsp;of&nbsp;the&nbsp;SQL&nbsp;statement&nbsp;that&nbsp;is&nbsp;currently&nbsp;being&nbsp;executed </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 27 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> SQL_EXEC_START </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> DATE </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 该会话开始执行该SQL语句的时间。若SQL_ID为空，则该列为空。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Time&nbsp;when&nbsp;the&nbsp;execution&nbsp;of&nbsp;the&nbsp;SQL&nbsp;currently&nbsp;executed&nbsp;by&nbsp;this&nbsp;session&nbsp;started;&nbsp;NULL&nbsp;if&nbsp;SQL_ID&nbsp;is&nbsp;NULL </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 28 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> SQL_EXEC_ID </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> SQL执行的标识符ID。若SQL_ID为空或SQL还未开始执行，则该列为空。对应于V$SQL_MONITOR.SQL_EXEC_ID列。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> SQL&nbsp;execution&nbsp;identifier;&nbsp;NULL&nbsp;if&nbsp;SQL_ID&nbsp;is&nbsp;NULL&nbsp;or&nbsp;if&nbsp;the&nbsp;execution&nbsp;of&nbsp;that&nbsp;SQL&nbsp;has&nbsp;not&nbsp;yet&nbsp;started&nbsp;(see&nbsp;V$SQL_MONITOR) </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 29 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> PREV_SQL_ADDR </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> RAW(4&nbsp;|&nbsp;8) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 与PREV_HASH_VALUE一起使用标识上一次执行的SQL语句。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Used&nbsp;with&nbsp;PREV_HASH_VALUE&nbsp;to&nbsp;identify&nbsp;the&nbsp;last&nbsp;SQL&nbsp;statement&nbsp;executed </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 30 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> PREV_HASH_VALUE </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 与SQL_HASH_VALUE一起使用标识上一次执行的SQL语句。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Used&nbsp;with&nbsp;SQL_HASH_VALUE&nbsp;to&nbsp;identify&nbsp;the&nbsp;last&nbsp;SQL&nbsp;statement&nbsp;executed </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 31 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> PREV_SQL_ID </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> VARCHAR2(13) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 上一次执行的SQL语句ID。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> SQL&nbsp;identifier&nbsp;of&nbsp;the&nbsp;last&nbsp;SQL&nbsp;statement&nbsp;executed </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 32 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> PREV_CHILD_NUMBER </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 上一次执行的SQL语句的子游标ID。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Child&nbsp;number&nbsp;of&nbsp;the&nbsp;last&nbsp;SQL&nbsp;statement&nbsp;executed </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 33 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> PREV_EXEC_START </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> DATE </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 上一次执行SQL语句的开始时间。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> SQL&nbsp;execution&nbsp;start&nbsp;of&nbsp;the&nbsp;last&nbsp;executed&nbsp;SQL&nbsp;statement </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 34 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> PREV_EXEC_ID </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 上一次执行SQL语句的执行ID。对应于V$SQL_MONITOR.SQL_EXEC_ID列。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> SQL&nbsp;execution&nbsp;identifier&nbsp;of&nbsp;the&nbsp;last&nbsp;executed&nbsp;SQL&nbsp;statement </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 35 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> PLSQL_ENTRY_OBJECT_ID </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Object&nbsp;ID&nbsp;of&nbsp;the&nbsp;top-most&nbsp;PL/SQL&nbsp;subprogram&nbsp;on&nbsp;the&nbsp;stack;&nbsp;NULL&nbsp;if&nbsp;there&nbsp;is&nbsp;no&nbsp;PL/SQL&nbsp;subprogram&nbsp;on&nbsp;the&nbsp;stack </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 36 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> PLSQL_ENTRY_SUBPROGRAM_ID </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Subprogram&nbsp;ID&nbsp;of&nbsp;the&nbsp;top-most&nbsp;PL/SQL&nbsp;subprogram&nbsp;on&nbsp;the&nbsp;stack;&nbsp;NULL&nbsp;if&nbsp;there&nbsp;is&nbsp;no&nbsp;PL/SQL&nbsp;subprogram&nbsp;on&nbsp;the&nbsp;stack </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 37 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> PLSQL_OBJECT_ID </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Object&nbsp;ID&nbsp;of&nbsp;the&nbsp;currently&nbsp;executing&nbsp;PL/SQL&nbsp;subprogram;&nbsp;NULL&nbsp;if&nbsp;executing&nbsp;SQL </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 38 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> PLSQL_SUBPROGRAM_ID </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Subprogram&nbsp;ID&nbsp;of&nbsp;the&nbsp;currently&nbsp;executing&nbsp;PL/SQL&nbsp;object;&nbsp;NULL&nbsp;if&nbsp;executing&nbsp;SQL </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 39 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> <a rel="nofollow">MODULE</a> </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> VARCHAR2(48) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 包含当前正在执行的模块名，正如由调用DBMS_APPLICATION_INFO.SET_MODULE过程所设置MODULE_HASHNUMBER上面MODULE的散列值。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Name&nbsp;of&nbsp;the&nbsp;currently&nbsp;executing&nbsp;module&nbsp;as&nbsp;set&nbsp;by&nbsp;calling&nbsp;the&nbsp;DBMS_APPLICATION_INFO.SET_MODULE&nbsp;procedure </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 40 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> MODULE_HASH </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> MODULE列的HASH值。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Hash&nbsp;value&nbsp;of&nbsp;the&nbsp;MODULE&nbsp;column </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 41 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> <a rel="nofollow">ACTION</a> </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> VARCHAR2(32) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 包含当前执行活动的名称，正如由调用DBMS_APPLICATION_INFO.SET_ACTION过程所设置ACTION_HASHNUMBER上列活动名称的散列值。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Name&nbsp;of&nbsp;the&nbsp;currently&nbsp;executing&nbsp;action&nbsp;as&nbsp;set&nbsp;by&nbsp;calling&nbsp;the&nbsp;DBMS_APPLICATION_INFO.SET_ACTION&nbsp;procedure </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 42 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> ACTION_HASH </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> ACTION列的HASH值。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Hash&nbsp;value&nbsp;of&nbsp;the&nbsp;ACTION&nbsp;column </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 43 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> CLIENT_INFO </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> VARCHAR2(64) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 由DBMS_APPLICATION_INFO.SET_CLIENT_INFO过程设置的信息。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Information&nbsp;set&nbsp;by&nbsp;the&nbsp;DBMS_APPLICATION_INFO.SET_CLIENT_INFO&nbsp;procedure </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 44 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> FIXED_TABLE_SEQUENCE </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 此列包含一个数，每当会话完成一个数据库调用并且存在来自动态性能表的介入选择，它个数就增加。这个列可被性能监控程序用来监控数据库中的统计数据。每当性能监控程序查看数据库时，只需要查看当前活动的会话或在这个列中具有比上次性能监控程序所看到的最大值更大的值的会话即可。所有其他会话自上次性能监控程序查看数据库以来都是空闲的。 &nbsp;当session完成一个user&nbsp;call后就会增加的一个数值，也就是说，如果session&nbsp;inactive，它就不会增加。因此可以根据此字段的值变化来监控某个时间点以来的session的性能情况。例如，一个小时以前，某个session的FIXED_TABLE_SEQUENCE是10000，而现在是20000，则表明一个小时内其user&nbsp;call比较频繁，可以重点关注此session的performance&nbsp;statistics。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> This&nbsp;contains&nbsp;a&nbsp;number&nbsp;that&nbsp;increases&nbsp;every&nbsp;time&nbsp;the&nbsp;session&nbsp;completes&nbsp;a&nbsp;call&nbsp;to&nbsp;the&nbsp;database&nbsp;and&nbsp;there&nbsp;has&nbsp;been&nbsp;an&nbsp;intervening&nbsp;select&nbsp;from&nbsp;a&nbsp;dynamic&nbsp;performance&nbsp;table.&nbsp;This&nbsp;column&nbsp;can&nbsp;be&nbsp;used&nbsp;by&nbsp;performance&nbsp;monitors&nbsp;to&nbsp;monitor&nbsp;statistics&nbsp;in&nbsp;the&nbsp;database.&nbsp;Each&nbsp;time&nbsp;the&nbsp;performance&nbsp;monitor&nbsp;looks&nbsp;at&nbsp;the&nbsp;database,&nbsp;it&nbsp;only&nbsp;needs&nbsp;to&nbsp;look&nbsp;at&nbsp;sessions&nbsp;that&nbsp;are&nbsp;currently&nbsp;active&nbsp;or&nbsp;have&nbsp;a&nbsp;higher&nbsp;value&nbsp;in&nbsp;this&nbsp;column&nbsp;than&nbsp;the&nbsp;highest&nbsp;value&nbsp;that&nbsp;the&nbsp;performance&nbsp;monitor&nbsp;saw&nbsp;the&nbsp;last&nbsp;time.&nbsp;All&nbsp;the&nbsp;other&nbsp;sessions&nbsp;have&nbsp;been&nbsp;idle&nbsp;since&nbsp;the&nbsp;last&nbsp;time&nbsp;the&nbsp;performance&nbsp;monitor&nbsp;looked&nbsp;at&nbsp;the&nbsp;database. </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 45 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> ROW_WAIT_OBJ# </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 被锁定行所在TABLE的OBJECT_ID，该列和DBA_OBJECTS中的OBJECT_ID关联可以得到被锁定的表名。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Object&nbsp;ID&nbsp;for&nbsp;the&nbsp;table&nbsp;containing&nbsp;the&nbsp;row&nbsp;specified&nbsp;in&nbsp;ROW_WAIT_ROW# </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 46 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> ROW_WAIT_FILE# </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 被锁定行所在的数据文件号，该列和v$datafile中的file#关联可以得到数据文件名。此列仅在会话当前正在等待其它事务处理提交并且ROW_WAIT_OBJ#不为-1时有效。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Identifier&nbsp;for&nbsp;the&nbsp;datafile&nbsp;containing&nbsp;the&nbsp;row&nbsp;specified&nbsp;in&nbsp;ROW_WAIT_ROW#.&nbsp;This&nbsp;column&nbsp;is&nbsp;valid&nbsp;only&nbsp;if&nbsp;the&nbsp;session&nbsp;is&nbsp;currently&nbsp;waiting&nbsp;for&nbsp;another&nbsp;transaction&nbsp;to&nbsp;commit&nbsp;and&nbsp;the&nbsp;value&nbsp;of&nbsp;ROW_WAIT_OBJ#&nbsp;is&nbsp;not&nbsp;-1. </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 47 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> ROW_WAIT_BLOCK# </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 被锁定行所在的数据块号。此列仅在会话当前正在等待其它事务处理提交并且ROW_WAIT_OBJ#不为-1时有效。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Identifier&nbsp;for&nbsp;the&nbsp;block&nbsp;containing&nbsp;the&nbsp;row&nbsp;specified&nbsp;in&nbsp;ROW_WAIT_ROW#.&nbsp;This&nbsp;column&nbsp;is&nbsp;valid&nbsp;only&nbsp;if&nbsp;the&nbsp;session&nbsp;is&nbsp;currently&nbsp;waiting&nbsp;for&nbsp;another&nbsp;transaction&nbsp;to&nbsp;commit&nbsp;and&nbsp;the&nbsp;value&nbsp;of&nbsp;ROW_WAIT_OBJ#&nbsp;is&nbsp;not&nbsp;-1. </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 48 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> ROW_WAIT_ROW# </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 被锁定的当前行的行号。此列仅在会话当前正在等待其它事务处理提交并且ROW_WAIT_OBJ#不为-1时有效。 可以通过ROW_WAIT_OBJ#、ROW_WAIT_FILE#、ROW_WAIT_BLOCK#和ROW_WAIT_ROW#这4个字段查询现在正在被锁的表的相关信息（ROWID），例如，表名、文件名及行号。 SELECT&nbsp;DBMS_ROWID.ROWID_CREATE(1, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(SELECT&nbsp;DATA_OBJECT_ID&nbsp;FROM&nbsp;DBA_OBJECTS&nbsp;WHERE&nbsp;OBJECT_ID&nbsp;=&nbsp;ROW_WAIT_OBJ#), &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ROW_WAIT_FILE#, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ROW_WAIT_BLOCK#, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ROW_WAIT_ROW#), &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;A.ROW_WAIT_OBJ#, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;A.ROW_WAIT_FILE#, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;A.ROW_WAIT_BLOCK#, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;A.ROW_WAIT_ROW#, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(SELECT&nbsp;D.OWNER&nbsp;||&nbsp;'.'&nbsp;||&nbsp;D.OBJECT_NAME&nbsp;FROM&nbsp;DBA_OBJECTS&nbsp;D&nbsp;WHERE&nbsp;OBJECT_ID&nbsp;=&nbsp;ROW_WAIT_OBJ#)&nbsp;OBJECT_NAME &nbsp;&nbsp;FROM&nbsp;V$SESSION&nbsp;A &nbsp;WHERE&nbsp;A.ROW_WAIT_OBJ#&nbsp;&lt;&gt;&nbsp;-1; </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Current&nbsp;row&nbsp;being&nbsp;locked.&nbsp;This&nbsp;column&nbsp;is&nbsp;valid&nbsp;only&nbsp;if&nbsp;the&nbsp;session&nbsp;is&nbsp;currently&nbsp;waiting&nbsp;for&nbsp;another&nbsp;transaction&nbsp;to&nbsp;commit&nbsp;and&nbsp;the&nbsp;value&nbsp;of&nbsp;ROW_WAIT_OBJ#&nbsp;is&nbsp;not&nbsp;-1. </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 49 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> TOP_LEVEL_CALL# </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Oracle&nbsp;top&nbsp;level&nbsp;call&nbsp;number </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 50 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> LOGON_TIME </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> DATE </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 用户的登录时间 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Time&nbsp;of&nbsp;logon </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 51 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> LAST_CALL_ET </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 用户最后一条语句执行完毕后到sysdate的时间，单位为秒。每次用户执行一个新的语句后，该字段复位为0，重新开始记数。可以通过该字段来获得一个连接用户最后一次操作数据库后的空闲时间。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> If&nbsp;the&nbsp;session&nbsp;STATUS&nbsp;is&nbsp;currently&nbsp;ACTIVE,&nbsp;then&nbsp;the&nbsp;value&nbsp;represents&nbsp;the&nbsp;elapsed&nbsp;time&nbsp;(in&nbsp;seconds)&nbsp;since&nbsp;the&nbsp;session&nbsp;has&nbsp;become&nbsp;active.If&nbsp;the&nbsp;session&nbsp;STATUS&nbsp;is&nbsp;currently&nbsp;INACTIVE,&nbsp;then&nbsp;the&nbsp;value&nbsp;represents&nbsp;the&nbsp;elapsed&nbsp;time&nbsp;(in&nbsp;seconds)&nbsp;since&nbsp;the&nbsp;session&nbsp;has&nbsp;become&nbsp;inactive. </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 52 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> FAILOVER_TYPE </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> VARCHAR2(13) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 表示TAF的类型， 1.SESSION：表示在故障切换发生后，新的连接会被创建到正常实例，问题出现时正在运行的操作不会被继续执行。 2.SELECT：表示在故障切换发生后，新的连接会被创建到正常实例，问题出现时正在运行的SELECT语句会被继续执行，在新的节点上继续返回后续结果集，而已经返回的记录集则抛弃。 3.NONE：表示不会发生故障切换，即禁用TAF。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Indicates&nbsp;whether&nbsp;and&nbsp;to&nbsp;what&nbsp;extent&nbsp;transparent&nbsp;application&nbsp;failover&nbsp;(TAF)&nbsp;is&nbsp;enabled&nbsp;for&nbsp;the&nbsp;session: NONE&nbsp;-&nbsp;Failover&nbsp;is&nbsp;disabled&nbsp;for&nbsp;this&nbsp;session SESSION&nbsp;-&nbsp;Client&nbsp;is&nbsp;able&nbsp;to&nbsp;fail&nbsp;over&nbsp;its&nbsp;session&nbsp;following&nbsp;a&nbsp;disconnect SELECT&nbsp;-&nbsp;Client&nbsp;is&nbsp;able&nbsp;to&nbsp;fail&nbsp;over&nbsp;queries&nbsp;in&nbsp;progress&nbsp;as&nbsp;well See&nbsp;Also: Oracle&nbsp;Database&nbsp;Concepts&nbsp;for&nbsp;more&nbsp;information&nbsp;on&nbsp;TAF Oracle&nbsp;Database&nbsp;Net&nbsp;Services&nbsp;Administrator's&nbsp;Guide&nbsp;for&nbsp;information&nbsp;on&nbsp;configuring&nbsp;TAF </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 53 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> FAILOVER_METHOD </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> VARCHAR2(10) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 指定TAF的方法，可选项有BASIC（数据库会在故障切换时在目标实例中创建会话）和PRECONNECT（数据库会在最初建立连接时就同时建立到所有实例的连接，当发生故障时就可以立刻切换到其它链路上，这会对目标实例产生额外的工作负载）。需要注意的是，PRECONNECT选项只能用于客户端的TAF配置，不能用于服务端的TAF配置。BASIC方式在Failover时会有延迟，PRECONNECT方式虽然没有时间延迟，但是会建立多个冗余连接会消耗更多资源，两者就是用时间换资源和用资源换时间的区别。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Indicates&nbsp;the&nbsp;transparent&nbsp;application&nbsp;failover&nbsp;method&nbsp;for&nbsp;the&nbsp;session: NONE&nbsp;-&nbsp;Failover&nbsp;is&nbsp;disabled&nbsp;for&nbsp;this&nbsp;session BASIC&nbsp;-&nbsp;Client&nbsp;itself&nbsp;reconnects&nbsp;following&nbsp;a&nbsp;disconnect PRECONNECT&nbsp;-&nbsp;Backup&nbsp;instance&nbsp;can&nbsp;support&nbsp;all&nbsp;connections&nbsp;from&nbsp;every&nbsp;instance&nbsp;for&nbsp;which&nbsp;it&nbsp;is&nbsp;backed&nbsp;up </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 54 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> FAILED_OVER </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> VARCHAR2(3) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 若当前会话运行在故障切换模式并进行过故障切换，则为TRUE，否则为FALSE。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Indicates&nbsp;whether&nbsp;the&nbsp;session&nbsp;is&nbsp;running&nbsp;in&nbsp;failover&nbsp;mode&nbsp;and&nbsp;failover&nbsp;has&nbsp;occurred&nbsp;(YES)&nbsp;or&nbsp;not&nbsp;(NO) </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 55 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> RESOURCE_CONSUMER_GROUP </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> VARCHAR2(32) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 会话的当前资源使用者组的名称 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Name&nbsp;of&nbsp;the&nbsp;session's&nbsp;current&nbsp;resource&nbsp;consumer&nbsp;group </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 56 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> PDML_ENABLED </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> VARCHAR2(3) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 此列已被PDML_STATUS所替代。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> This&nbsp;column&nbsp;has&nbsp;been&nbsp;replaced&nbsp;by&nbsp;the&nbsp;PDML_STATUS&nbsp;column </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 57 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> PDML_STATUS </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> VARCHAR2(8) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 如果ENABLED，那么会话正处于PARALLEL&nbsp;DML启用方式。如果DISABLED，那么此会话不支持PARALLEL&nbsp;DML启用方式。如果FORCED，那么会话已经更改为强制PARALLEL&nbsp;DML。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> If&nbsp;ENABLED,&nbsp;the&nbsp;session&nbsp;is&nbsp;in&nbsp;a&nbsp;PARALLEL&nbsp;DML&nbsp;enabled&nbsp;mode.&nbsp;If&nbsp;DISABLED,&nbsp;PARALLEL&nbsp;DML&nbsp;enabled&nbsp;mode&nbsp;is&nbsp;not&nbsp;supported&nbsp;for&nbsp;the&nbsp;session.&nbsp;If&nbsp;FORCED,&nbsp;the&nbsp;session&nbsp;has&nbsp;been&nbsp;altered&nbsp;to&nbsp;force&nbsp;PARALLEL&nbsp;DML. </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 58 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> PDDL_STATUS </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> VARCHAR2(8) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;text-align:justify;vertical-align:middle;"> 如果ENABLED，那么会话正处于PARALLEL&nbsp;DDL启用方式。如果DISABLED，那么此会话不支持PARALLEL&nbsp;DDL启用方式。如果FORCED，那么会话已经更改为强制PARALLEL&nbsp;DDL。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> If&nbsp;ENABLED,&nbsp;the&nbsp;session&nbsp;is&nbsp;in&nbsp;a&nbsp;PARALLEL&nbsp;DDL&nbsp;enabled&nbsp;mode.&nbsp;If&nbsp;DISABLED,&nbsp;PARALLEL&nbsp;DDL&nbsp;enabled&nbsp;mode&nbsp;is&nbsp;not&nbsp;supported&nbsp;for&nbsp;the&nbsp;session.&nbsp;If&nbsp;FORCED,&nbsp;the&nbsp;session&nbsp;has&nbsp;been&nbsp;altered&nbsp;to&nbsp;force&nbsp;PARALLEL&nbsp;DDL. </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 59 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> PQ_STATUS </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> VARCHAR2(8) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;text-align:justify;vertical-align:middle;"> 如果ENABLED，那么会话正处于PARALLEL&nbsp;QUERY启用方式。如果DISABLED，那么此会话不支持PARALLEL&nbsp;QUERY启用方式。如果FORCED，那么会话已经更改为强制PARALLEL&nbsp;QUERY。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> If&nbsp;ENABLED,&nbsp;the&nbsp;session&nbsp;is&nbsp;in&nbsp;a&nbsp;PARALLEL&nbsp;QUERY&nbsp;enabled&nbsp;mode.&nbsp;If&nbsp;DISABLED,&nbsp;PARALLEL&nbsp;QUERY&nbsp;enabled&nbsp;mode&nbsp;is&nbsp;not&nbsp;supported&nbsp;for&nbsp;the&nbsp;session.&nbsp;If&nbsp;FORCED,&nbsp;the&nbsp;session&nbsp;has&nbsp;been&nbsp;altered&nbsp;to&nbsp;force&nbsp;PARALLEL&nbsp;QUERY. </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 60 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> CURRENT_QUEUE_DURATION </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> If&nbsp;queued&nbsp;(1),&nbsp;the&nbsp;current&nbsp;amount&nbsp;of&nbsp;time&nbsp;the&nbsp;session&nbsp;has&nbsp;been&nbsp;queued.&nbsp;If&nbsp;not&nbsp;currently&nbsp;queued,&nbsp;the&nbsp;value&nbsp;is&nbsp;0. </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 61 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> CLIENT_IDENTIFIER </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> VARCHAR2(64) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;text-align:justify;vertical-align:middle;"> 会话的客户端标识。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Client&nbsp;identifier&nbsp;of&nbsp;the&nbsp;session </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 62 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> BLOCKING_SESSION_STATUS </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> VARCHAR2(11) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 标识当前会话是否被阻塞。VALID表示当前会话被阻塞，可以通过BLOCKING_INSTANCE和&nbsp;BLOCKING_SESSION列查找到阻塞会话；“NO&nbsp;HOLDER”表示没有被阻塞；“NOT&nbsp;IN&nbsp;WAIT”表示当前会话未等待；UNKNOWN表示未知。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> This&nbsp;column&nbsp;provides&nbsp;details&nbsp;on&nbsp;whether&nbsp;there&nbsp;is&nbsp;a&nbsp;blocking&nbsp;session: VALID&nbsp;-&nbsp;there&nbsp;is&nbsp;a&nbsp;blocking&nbsp;session,&nbsp;and&nbsp;it&nbsp;is&nbsp;identified&nbsp;in&nbsp;the&nbsp;BLOCKING_INSTANCE&nbsp;and&nbsp;BLOCKING_SESSION&nbsp;columns NO&nbsp;HOLDER&nbsp;-&nbsp;there&nbsp;is&nbsp;no&nbsp;session&nbsp;blocking&nbsp;this&nbsp;session NOT&nbsp;IN&nbsp;WAIT&nbsp;-&nbsp;this&nbsp;session&nbsp;is&nbsp;not&nbsp;in&nbsp;a&nbsp;wait UNKNOWN&nbsp;-&nbsp;the&nbsp;blocking&nbsp;session&nbsp;is&nbsp;unknown </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 63 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> BLOCKING_INSTANCE </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 当BLOCKING_SESSION_STATUS的值为VALID时，该列表示阻塞会话的实例号（Instance&nbsp;Number）。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Instance&nbsp;identifier&nbsp;of&nbsp;the&nbsp;blocking&nbsp;session.&nbsp;This&nbsp;column&nbsp;is&nbsp;valid&nbsp;only&nbsp;if&nbsp;BLOCKING_SESSION_STATUS&nbsp;has&nbsp;the&nbsp;value&nbsp;VALID. </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 64 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> BLOCKING_SESSION </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 当BLOCKING_SESSION_STATUS的值为VALID时，该列表示阻塞会话的SID。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Session&nbsp;identifier&nbsp;of&nbsp;the&nbsp;blocking&nbsp;session.&nbsp;This&nbsp;column&nbsp;is&nbsp;valid&nbsp;only&nbsp;if&nbsp;BLOCKING_SESSION_STATUS&nbsp;has&nbsp;the&nbsp;value&nbsp;VALID. </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 65 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> FINAL_BLOCKING_SESSION_STATUS </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> VARCHAR2(11) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> The&nbsp;final&nbsp;blocking&nbsp;session&nbsp;is&nbsp;the&nbsp;final&nbsp;element&nbsp;in&nbsp;the&nbsp;wait&nbsp;chain&nbsp;constructed&nbsp;by&nbsp;following&nbsp;the&nbsp;sessions&nbsp;that&nbsp;are&nbsp;blocked&nbsp;by&nbsp;one&nbsp;another&nbsp;starting&nbsp;with&nbsp;this&nbsp;session.&nbsp;In&nbsp;the&nbsp;case&nbsp;of&nbsp;a&nbsp;cyclical&nbsp;wait&nbsp;chain,&nbsp;one&nbsp;of&nbsp;the&nbsp;sessions&nbsp;in&nbsp;the&nbsp;wait&nbsp;chain&nbsp;will&nbsp;be&nbsp;chosen&nbsp;as&nbsp;the&nbsp;final&nbsp;blocker. This&nbsp;column&nbsp;provides&nbsp;details&nbsp;on&nbsp;whether&nbsp;there&nbsp;is&nbsp;a&nbsp;final&nbsp;blocking&nbsp;session: VALID&nbsp;-&nbsp;there&nbsp;is&nbsp;a&nbsp;final&nbsp;blocking&nbsp;session&nbsp;and&nbsp;it&nbsp;is&nbsp;identified&nbsp;in&nbsp;the&nbsp;FINAL_BLOCKING_INSTANCE&nbsp;and&nbsp;FINAL_BLOCKING_SESSION&nbsp;columns NO&nbsp;HOLDER&nbsp;-&nbsp;there&nbsp;is&nbsp;no&nbsp;session&nbsp;blocking&nbsp;this&nbsp;session NOT&nbsp;IN&nbsp;WAIT&nbsp;-&nbsp;this&nbsp;session&nbsp;is&nbsp;not&nbsp;in&nbsp;a&nbsp;wait UNKNOWN&nbsp;-&nbsp;the&nbsp;final&nbsp;blocking&nbsp;session&nbsp;is&nbsp;unknown </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 66 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> FINAL_BLOCKING_INSTANCE </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Instance&nbsp;identifier&nbsp;of&nbsp;the&nbsp;final&nbsp;blocking&nbsp;session.&nbsp;This&nbsp;column&nbsp;is&nbsp;valid&nbsp;only&nbsp;if&nbsp;FINAL_BLOCKING_SESSION_STATUS&nbsp;has&nbsp;the&nbsp;value&nbsp;VALID. </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 67 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> FINAL_BLOCKING_SESSION </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Session&nbsp;identifier&nbsp;of&nbsp;the&nbsp;blocking&nbsp;session.&nbsp;This&nbsp;column&nbsp;is&nbsp;valid&nbsp;only&nbsp;if&nbsp;FINAL_BLOCKING_SESSION_STATUS&nbsp;has&nbsp;the&nbsp;value&nbsp;VALID. </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 68 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> SEQ# </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> A&nbsp;number&nbsp;that&nbsp;uniquely&nbsp;identifies&nbsp;the&nbsp;current&nbsp;or&nbsp;last&nbsp;wait&nbsp;(incremented&nbsp;for&nbsp;each&nbsp;wait) </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 69 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> EVENT# </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 等待事件的事件号，对应于V$EVENT_NAME.EVENT#列。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Event&nbsp;number </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 70 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> EVENT </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> VARCHAR2(64) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 等待事件的名称，若为空则表示ON&nbsp;CPU。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Resource&nbsp;or&nbsp;event&nbsp;for&nbsp;which&nbsp;the&nbsp;session&nbsp;is&nbsp;waiting See&nbsp;Also:&nbsp;Appendix&nbsp;C,&nbsp;"Oracle&nbsp;Wait&nbsp;Events" </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 71 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> P1TEXT </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> VARCHAR2(64) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Description&nbsp;of&nbsp;the&nbsp;first&nbsp;wait&nbsp;event&nbsp;parameter </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 72 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> P1 </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> First&nbsp;wait&nbsp;event&nbsp;parameter&nbsp;(in&nbsp;decimal) </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 73 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> P1RAW </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> RAW(8) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> <a rel="nofollow">First&nbsp;wait&nbsp;event&nbsp;parameter&nbsp;(in&nbsp;hexadecimal)Foot&nbsp;2&nbsp;</a> </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 74 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> P2TEXT </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> VARCHAR2(64) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Description&nbsp;of&nbsp;the&nbsp;second&nbsp;wait&nbsp;event&nbsp;parameter </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 75 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> P2 </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Second&nbsp;wait&nbsp;event&nbsp;parameter&nbsp;(in&nbsp;decimal) </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 76 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> P2RAW </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> RAW(8) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> <a rel="nofollow">Second&nbsp;wait&nbsp;event&nbsp;parameter&nbsp;(in&nbsp;hexadecimal)Footref&nbsp;2</a> </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 77 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> P3TEXT </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> VARCHAR2(64) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Description&nbsp;of&nbsp;the&nbsp;third&nbsp;wait&nbsp;event&nbsp;parameter </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 78 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> P3 </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Third&nbsp;wait&nbsp;event&nbsp;parameter&nbsp;(in&nbsp;decimal) </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 79 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> P3RAW </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> RAW(8) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> <a rel="nofollow">Third&nbsp;wait&nbsp;event&nbsp;parameter&nbsp;(in&nbsp;hexadecimal)Footref&nbsp;2</a> </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 80 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> WAIT_CLASS_ID </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Identifier&nbsp;of&nbsp;the&nbsp;class&nbsp;of&nbsp;the&nbsp;wait&nbsp;event </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 81 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> WAIT_CLASS# </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Number&nbsp;of&nbsp;the&nbsp;class&nbsp;of&nbsp;the&nbsp;wait&nbsp;event </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 82 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> WAIT_CLASS </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> VARCHAR2(64) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Name&nbsp;of&nbsp;the&nbsp;class&nbsp;of&nbsp;the&nbsp;wait&nbsp;event </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 83 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> WAIT_TIME </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> If&nbsp;the&nbsp;session&nbsp;is&nbsp;currently&nbsp;waiting,&nbsp;then&nbsp;the&nbsp;value&nbsp;is&nbsp;0.&nbsp;If&nbsp;the&nbsp;session&nbsp;is&nbsp;not&nbsp;in&nbsp;a&nbsp;wait,&nbsp;then&nbsp;the&nbsp;value&nbsp;is&nbsp;as&nbsp;follows: &gt;&nbsp;0&nbsp;-&nbsp;Value&nbsp;is&nbsp;the&nbsp;duration&nbsp;of&nbsp;the&nbsp;last&nbsp;wait&nbsp;in&nbsp;hundredths&nbsp;of&nbsp;a&nbsp;second -1&nbsp;-&nbsp;Duration&nbsp;of&nbsp;the&nbsp;last&nbsp;wait&nbsp;was&nbsp;less&nbsp;than&nbsp;a&nbsp;hundredth&nbsp;of&nbsp;a&nbsp;second -2&nbsp;-&nbsp;Parameter&nbsp;TIMED_STATISTICS&nbsp;was&nbsp;set&nbsp;to&nbsp;false This&nbsp;column&nbsp;has&nbsp;been&nbsp;deprecated&nbsp;in&nbsp;favor&nbsp;of&nbsp;the&nbsp;columns&nbsp;WAIT_TIME_MICRO&nbsp;and&nbsp;STATE. </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 84 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> SECONDS_IN_WAIT </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> If&nbsp;the&nbsp;session&nbsp;is&nbsp;currently&nbsp;waiting,&nbsp;then&nbsp;the&nbsp;value&nbsp;is&nbsp;the&nbsp;amount&nbsp;of&nbsp;time&nbsp;waited&nbsp;for&nbsp;the&nbsp;current&nbsp;wait.&nbsp;If&nbsp;the&nbsp;session&nbsp;is&nbsp;not&nbsp;in&nbsp;a&nbsp;wait,&nbsp;then&nbsp;the&nbsp;value&nbsp;is&nbsp;the&nbsp;amount&nbsp;of&nbsp;time&nbsp;since&nbsp;the&nbsp;start&nbsp;of&nbsp;the&nbsp;last&nbsp;wait.This&nbsp;column&nbsp;has&nbsp;been&nbsp;deprecated&nbsp;in&nbsp;favor&nbsp;of&nbsp;the&nbsp;columns&nbsp;WAIT_TIME_MICRO&nbsp;and&nbsp;TIME_SINCE_LAST_WAIT_MICRO. </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 85 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> STATE </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> VARCHAR2(19) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Wait&nbsp;state: WAITING&nbsp;-&nbsp;Session&nbsp;is&nbsp;currently&nbsp;waiting WAITED&nbsp;UNKNOWN&nbsp;TIME&nbsp;-&nbsp;Duration&nbsp;of&nbsp;the&nbsp;last&nbsp;wait&nbsp;is&nbsp;unknown;&nbsp;this&nbsp;is&nbsp;the&nbsp;value&nbsp;when&nbsp;the&nbsp;parameter&nbsp;TIMED_STATISTICS&nbsp;is&nbsp;set&nbsp;to&nbsp;false WAITED&nbsp;SHORT&nbsp;TIME&nbsp;-&nbsp;Last&nbsp;wait&nbsp;was&nbsp;less&nbsp;than&nbsp;a&nbsp;hundredth&nbsp;of&nbsp;a&nbsp;second WAITED&nbsp;KNOWN&nbsp;TIME&nbsp;-&nbsp;Duration&nbsp;of&nbsp;the&nbsp;last&nbsp;wait&nbsp;is&nbsp;specified&nbsp;in&nbsp;the&nbsp;WAIT_TIME&nbsp;column </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 86 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> WAIT_TIME_MICRO </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Amount&nbsp;of&nbsp;time&nbsp;waited&nbsp;(in&nbsp;microseconds).&nbsp;If&nbsp;the&nbsp;session&nbsp;is&nbsp;currently&nbsp;waiting,&nbsp;then&nbsp;the&nbsp;value&nbsp;is&nbsp;the&nbsp;time&nbsp;spent&nbsp;in&nbsp;the&nbsp;current&nbsp;wait.&nbsp;If&nbsp;the&nbsp;session&nbsp;is&nbsp;currently&nbsp;not&nbsp;in&nbsp;a&nbsp;wait,&nbsp;then&nbsp;the&nbsp;value&nbsp;is&nbsp;the&nbsp;amount&nbsp;of&nbsp;time&nbsp;waited&nbsp;in&nbsp;the&nbsp;last&nbsp;wait. </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 87 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> TIME_REMAINING_MICRO </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Value&nbsp;is&nbsp;interpreted&nbsp;as&nbsp;follows: &gt;&nbsp;0&nbsp;-&nbsp;Amount&nbsp;of&nbsp;time&nbsp;remaining&nbsp;for&nbsp;the&nbsp;current&nbsp;wait&nbsp;(in&nbsp;microseconds) 0&nbsp;-&nbsp;Current&nbsp;wait&nbsp;has&nbsp;timed&nbsp;out -1&nbsp;-&nbsp;Session&nbsp;can&nbsp;indefinitely&nbsp;wait&nbsp;in&nbsp;the&nbsp;current&nbsp;wait NULL&nbsp;-&nbsp;Session&nbsp;is&nbsp;not&nbsp;currently&nbsp;waiting </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 88 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> TIME_SINCE_LAST_WAIT_MICRO </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Time&nbsp;elapsed&nbsp;since&nbsp;the&nbsp;end&nbsp;of&nbsp;the&nbsp;last&nbsp;wait&nbsp;(in&nbsp;microseconds).&nbsp;If&nbsp;the&nbsp;session&nbsp;is&nbsp;currently&nbsp;in&nbsp;a&nbsp;wait,&nbsp;then&nbsp;the&nbsp;value&nbsp;is&nbsp;0. </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 89 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> SERVICE_NAME </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> VARCHAR2(64) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Service&nbsp;name&nbsp;of&nbsp;the&nbsp;session </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 90 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> SQL_TRACE </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> VARCHAR2(8) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Indicates&nbsp;whether&nbsp;SQL&nbsp;tracing&nbsp;is&nbsp;enabled&nbsp;(ENABLED)&nbsp;or&nbsp;disabled&nbsp;(DISABLED) </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 91 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> SQL_TRACE_WAITS </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> VARCHAR2(5) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Indicates&nbsp;whether&nbsp;wait&nbsp;tracing&nbsp;is&nbsp;enabled&nbsp;(TRUE)&nbsp;or&nbsp;not&nbsp;(FALSE) </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 92 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> SQL_TRACE_BINDS </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> VARCHAR2(5) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Indicates&nbsp;whether&nbsp;bind&nbsp;tracing&nbsp;is&nbsp;enabled&nbsp;(TRUE)&nbsp;or&nbsp;not&nbsp;(FALSE) </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 93 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> SQL_TRACE_PLAN_STATS </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> VARCHAR2(10) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Frequency&nbsp;at&nbsp;which&nbsp;row&nbsp;source&nbsp;statistics&nbsp;are&nbsp;dumped&nbsp;in&nbsp;the&nbsp;trace&nbsp;files&nbsp;for&nbsp;each&nbsp;cursor: never first_execution all_executions </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 94 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> SESSION_EDITION_ID </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Shows&nbsp;the&nbsp;value&nbsp;that,&nbsp;in&nbsp;the&nbsp;session,&nbsp;would&nbsp;be&nbsp;reported&nbsp;by&nbsp;sys_context('USERENV',&nbsp;'SESSION_EDITION_ID') </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 95 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> CREATOR_ADDR </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> RAW(4&nbsp;|&nbsp;8) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> 对应V$PROCESS的ADDR列，若当前会话为KILLED状态的话，则可以使用该列来返回会话的地址。 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Address&nbsp;of&nbsp;the&nbsp;creating&nbsp;process&nbsp;or&nbsp;circuit </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 96 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> CREATOR_SERIAL# </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Serial&nbsp;number&nbsp;of&nbsp;the&nbsp;creating&nbsp;process&nbsp;or&nbsp;circuit </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 97 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> ECID </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> VARCHAR2(64) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Execution&nbsp;context&nbsp;identifier&nbsp;(sent&nbsp;by&nbsp;Application&nbsp;Server) </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 98 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> SQL_TRANSLATION_PROFILE_ID </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> </td> 
 <td style="font-family:'courier new';color:#222222;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Object&nbsp;number&nbsp;of&nbsp;the&nbsp;SQL&nbsp;translation&nbsp;profile </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 12c </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 99 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> PGA_TUNABLE_MEM </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> </td> 
 <td style="font-family:'courier new';color:#222222;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> The&nbsp;amount&nbsp;of&nbsp;tunable&nbsp;PGA&nbsp;memory&nbsp;(in&nbsp;bytes). Untunable&nbsp;memory&nbsp;is&nbsp;PGA_ALLOC_MEM&nbsp;from&nbsp;V$PROCESS&nbsp;minus&nbsp;PGA_TUNABLE_MEM&nbsp;from&nbsp;V$SESSION. </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 12c </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 100 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> SHARD_DDL_STATUS </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> VARCHAR2(8) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> </td> 
 <td style="font-family:'courier new';color:#222222;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Indicates&nbsp;whether&nbsp;shard&nbsp;DDL&nbsp;is&nbsp;enabled&nbsp;in&nbsp;the&nbsp;current&nbsp;session&nbsp;(ENABLED)&nbsp;or&nbsp;not&nbsp;(DISABLED). This&nbsp;value&nbsp;is&nbsp;only&nbsp;relevant&nbsp;for&nbsp;the&nbsp;shard&nbsp;catalog&nbsp;database. </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 12cR2 </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 101 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> CON_ID </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> NUMBER </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> </td> 
 <td style="font-family:'courier new';color:#222222;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> The&nbsp;ID&nbsp;of&nbsp;the&nbsp;container&nbsp;to&nbsp;which&nbsp;the&nbsp;data&nbsp;pertains.&nbsp;Possible&nbsp;values&nbsp;include: 0:&nbsp;This&nbsp;value&nbsp;is&nbsp;used&nbsp;for&nbsp;rows&nbsp;containing&nbsp;data&nbsp;that&nbsp;pertain&nbsp;to&nbsp;the&nbsp;entire&nbsp;CDB.&nbsp;This&nbsp;value&nbsp;is&nbsp;also&nbsp;used&nbsp;for&nbsp;rows&nbsp;in&nbsp;non-CDBs. 1:&nbsp;This&nbsp;value&nbsp;is&nbsp;used&nbsp;for&nbsp;rows&nbsp;containing&nbsp;data&nbsp;that&nbsp;pertain&nbsp;to&nbsp;only&nbsp;the&nbsp;root n:&nbsp;Where&nbsp;n&nbsp;is&nbsp;the&nbsp;applicable&nbsp;container&nbsp;ID&nbsp;for&nbsp;the&nbsp;rows&nbsp;containing&nbsp;data </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 12c </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 102 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> EXTERNAL_NAME </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> VARCHAR2(1024) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> </td> 
 <td style="font-family:'courier new';color:#222222;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> External&nbsp;name&nbsp;of&nbsp;the&nbsp;database&nbsp;user.&nbsp;For&nbsp;enterprise&nbsp;users,&nbsp;returns&nbsp;the&nbsp;Oracle&nbsp;Internet&nbsp;Directory&nbsp;DN. </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 12c </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 103 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> <a rel="nofollow">PLSQL_DEBUGGER_CONNECTED&nbsp;</a> </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> VARCHAR2(5) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> </td> 
 <td style="font-family:'courier new';color:#222222;font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;"> Indicates&nbsp;whether&nbsp;the&nbsp;session&nbsp;is&nbsp;connected&nbsp;to&nbsp;a&nbsp;PL/SQL&nbsp;debugger.&nbsp;Possible&nbsp;values: TRUE FALSE </td> 
 <td style="font-size:9pt;vertical-align:middle;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';color:#000000;text-align:center;"> 12c </td> 
 </tr> 
 </tbody> 
</table>

--------------------

[Oracle 11g中v$session视图server列的含义][Oracle 11g_v_session_server]

原文地址：[Oracle 11g中v$session视图server列的含义][Oracle 11g_v_session_server 1] 作者：[hoegh][]

V$SESSION是基础信息视图，用于找寻用户SID或SADDR。不过，它也有一些列会动态的变化，可用于检查用户。在该视图中，每一个连接到数据库实例中的session都拥有一条记录，包括用户session及后台进程如DBWR，LGWR，arcchiver等等。  
 V$SESSION视图包含很多列，涉及到session信息、client信息以及application信息等。其中，server列信息表示该session的连接类型，也就是咱们常说的共享服务器连接或者专用服务器连接。那有没有其他服务器连接类型呢？下面我们就看一下Oracle11g官方文档中server列的几个取值：

*  **DEDICATED**
 *  **SHARED**
 *  **PSEUDO**
 *  **POOLED**
 *  **NONE**

其中，DEDICATED表示专用服务器连接，SHARED表示共享服务器连接，这两个大家较为熟悉；  
 PSEUDO和kill session相关，如果发出ALTER SYSTEM去终止session的会话，等待60秒后没有终止session，会收到一个信息表明session已标识为终止。被标记为终止的session在v$seession的status为KILLED，对应的server值可能为PSEUDO；  
 PO OLED和Oracle 11g推出的驻留连接池（Database Resident Connection Pool）特性相关，驻留连接池提供了数据库层面上的连接池管理机制，为应对高并发、短会话前端应用进行有益的尝试， PO OLED表示使用驻留连接池技术的连接；  
 NONE表示空闲的共享服务器连接。

**hoegh**

**2016.01.31**

**-- The End --**

--------------------

[v$session中LAST\_CALL\_ET参数的理解][v_session_LAST_CALL_ET]

原文地址：[v$session中LAST\_CALL\_ET参数的理解][v_session_LAST_CALL_ET 1] 作者：[zhanglei\_itput][zhanglei_itput]

在实际的数据库应用中，我们经常遇到这样一个问题，连接到Oracle数据库的用户在作了一次操作后，再也没有后续操作，但却长时间没有和数据库断开连接。最近在研究一个中间件到数据库中的长连接异常问题，查询到v$session中LAST\_CALL\_ET参数，觉得这个参数很有用，下面是自己的一点理解：  
  
 1. **参数定义**  
 LOGON\_TIME 是一个日期型（Date）字段，为用户登陆时间；   
 LAST\_CALL\_ET是一个数字型（Number）字段，其含义是用户最后一条语句执行完毕后到sysdate的时间，单位为秒。每次用户执行一个新的语句后，该字段复位为0，重新开始记数。我们可以通过该字段来获得一个连接用户最后一次操作数据库后的空闲时间。  
 针对这两个参数定义的测试:  
SQL> conn [system/oracle@devdb2][system_oracle_devdb2];  
 已连接。  
 SQL> select ses.SID,ses.username,ses.machine,ses.program,ses.last\_call\_et,sql.hash\_value,sql.sql\_text  
 from v$session ses, v$sql sql  
 where ses.sql\_hash\_value = sql.hash\_value(+)  
 and ses.PROGRAM = 'sqlplus.exe'

<table style="font-family:'courier new';color:#000000;font-size:16px;"> 
 <tbody> 
 <tr style="font-family:'courier new';color:#000000;font-size:16px;"> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;border-width:.5pt;border-style:solid;width:25pt;"> SID </td> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;border-right:.5pt solid;border-top:.5pt solid;border-left:;width:51pt;border-bottom:.5pt solid;"> USERNAME </td> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;border-right:.5pt solid;border-top:.5pt solid;border-left:;width:62pt;border-bottom:.5pt solid;"> MACHINE </td> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;border-right:.5pt solid;border-top:.5pt solid;border-left:;width:68pt;border-bottom:.5pt solid;"> PROGRAM </td> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;border-right:.5pt solid;border-top:.5pt solid;border-left:;width:74pt;border-bottom:.5pt solid;"> LAST_CALL_ET </td> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;border-right:.5pt solid;border-top:.5pt solid;border-left:;width:62pt;border-bottom:.5pt solid;"> HASH_VALUE </td> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;border-right:.5pt solid;border-top:.5pt solid;border-left:;width:219pt;border-bottom:.5pt solid;"> SQL_TEXT </td> 
 </tr> 
 <tr style="font-family:'courier new';color:#000000;font-size:16px;"> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;border-right:.5pt solid;border-top:;border-left:.5pt solid;border-bottom:.5pt solid;"> 132 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;border-right:.5pt solid;border-top:;border-left:;border-bottom:.5pt solid;"> SYSTEM </td> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;border-right:.5pt solid;border-top:;border-left:;border-bottom:.5pt solid;"> ZDC\BEILEI </td> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;border-right:.5pt solid;border-top:;border-left:;border-bottom:.5pt solid;"> sqlplus.exe </td> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;border-right:.5pt solid;border-top:;border-left:;border-bottom:.5pt solid;"> 3(登陆后的时间) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;border-right:.5pt solid;border-top:;border-left:;border-bottom:.5pt solid;"> 　 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;border-right:.5pt solid;border-top:;border-left:;border-bottom:.5pt solid;"> 　 </td> 
 </tr> 
 </tbody> 
</table>

SQL> select count(\*) from user\_object\_size;

<table style="font-family:'courier new';color:#000000;font-size:16px;"> 
 <tbody> 
 <tr style="font-family:'courier new';color:#000000;font-size:16px;"> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;border-width:.5pt;border-style:solid;width:25pt;"> SID </td> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;border-right:.5pt solid;border-top:.5pt solid;border-left:;width:51pt;border-bottom:.5pt solid;"> USERNAME </td> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;border-right:.5pt solid;border-top:.5pt solid;border-left:;width:62pt;border-bottom:.5pt solid;"> MACHINE </td> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;border-right:.5pt solid;border-top:.5pt solid;border-left:;width:68pt;border-bottom:.5pt solid;"> PROGRAM </td> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;border-right:.5pt solid;border-top:.5pt solid;border-left:;width:74pt;border-bottom:.5pt solid;"> LAST_CALL_ET </td> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;border-right:.5pt solid;border-top:.5pt solid;border-left:;width:62pt;border-bottom:.5pt solid;"> HASH_VALUE </td> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;border-right:.5pt solid;border-top:.5pt solid;border-left:;width:219pt;border-bottom:.5pt solid;"> SQL_TEXT </td> 
 </tr> 
 <tr style="font-family:'courier new';color:#000000;font-size:16px;"> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;border-right:.5pt solid;border-top:;border-left:.5pt solid;border-bottom:.5pt solid;"> 132 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;border-right:.5pt solid;border-top:;border-left:;border-bottom:.5pt solid;"> SYSTEM </td> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;border-right:.5pt solid;border-top:;border-left:;border-bottom:.5pt solid;"> ZDC\BEILEI </td> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;border-right:.5pt solid;border-top:;border-left:;border-bottom:.5pt solid;"> sqlplus.exe </td> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;border-right:.5pt solid;border-top:;border-left:;border-bottom:.5pt solid;"> 24(sql执行的时间) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;border-right:.5pt solid;border-top:;border-left:;border-bottom:.5pt solid;"> 178228611 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;border-right:.5pt solid;border-top:;border-left:;border-bottom:.5pt solid;"> select count(*) from user_object_size </td> 
 </tr> 
 </tbody> 
</table>

SQL> select count(\*) from user\_object\_size;  
 COUNT(\*)  
 \----------  
 20

<table style="font-family:'courier new';color:#000000;font-size:16px;"> 
 <tbody> 
 <tr style="font-family:'courier new';color:#000000;font-size:16px;"> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;border-width:.5pt;border-style:solid;width:25pt;"> SID </td> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;border-right:.5pt solid;border-top:.5pt solid;border-left:;width:51pt;border-bottom:.5pt solid;"> USERNAME </td> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;border-right:.5pt solid;border-top:.5pt solid;border-left:;width:62pt;border-bottom:.5pt solid;"> MACHINE </td> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;border-right:.5pt solid;border-top:.5pt solid;border-left:;width:68pt;border-bottom:.5pt solid;"> PROGRAM </td> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;border-right:.5pt solid;border-top:.5pt solid;border-left:;width:74pt;border-bottom:.5pt solid;"> LAST_CALL_ET </td> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;border-right:.5pt solid;border-top:.5pt solid;border-left:;width:62pt;border-bottom:.5pt solid;"> HASH_VALUE </td> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;border-right:.5pt solid;border-top:.5pt solid;border-left:;width:219pt;border-bottom:.5pt solid;"> SQL_TEXT </td> 
 </tr> 
 <tr style="font-family:'courier new';color:#000000;font-size:16px;"> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;border-right:.5pt solid;border-top:;border-left:.5pt solid;border-bottom:.5pt solid;"> 132 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;border-right:.5pt solid;border-top:;border-left:;border-bottom:.5pt solid;"> SYSTEM </td> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;border-right:.5pt solid;border-top:;border-left:;border-bottom:.5pt solid;"> ZDC\BEILEI </td> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;border-right:.5pt solid;border-top:;border-left:;border-bottom:.5pt solid;"> sqlplus.exe </td> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;border-right:.5pt solid;border-top:;border-left:;border-bottom:.5pt solid;"> 1(sql执行完,参数复位0，重新开始计算到sysdate的时间/s) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;border-right:.5pt solid;border-top:;border-left:;border-bottom:.5pt solid;"> 　 </td> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;border-right:.5pt solid;border-top:;border-left:;border-bottom:.5pt solid;"> 　 </td> 
 </tr> 
 </tbody> 
</table>

2. **识别超过一定空闲时间的连接**  
select username,logon\_time,last\_call\_et,   
 to\_char(sysdate-(last\_call\_et/(60\*60\*24)),'hh24:mi:ss') last\_work\_time  
 from v$session  
 where username is not null;  
  
 select ses.username,ses.machine,ses.program,ses.last\_call\_et,sql.hash\_value,sql.sql\_text  
 from v$session ses, v$sql sql  
 where ses.sql\_hash\_value = sql.hash\_value  
 and ses.last\_call\_et > 600  
 and ses.type = 'USER'

SELECT s.username 用户名称, s.status 状态,s.machine 机器名称,  
 　　　　osuser 操作系统用户名称,spid UNIX进程号,  
 'kill -9 '||spid UNIX级断开连接,  
 'alter system kill session ' ||''''||s.sid||',  
 '||s.serial\# || ''';' Oracle级断开连接,  
 TO\_CHAR (logon\_time, 'dd/mm/yyyy hh24:mi:ss') 登陆时间,  
 last\_call\_et 空闲时间秒,  
 TO\_CHAR (TRUNC (last\_call\_et / 3600, 0))||' '||' HRS '||  
 TO\_CHAR (TRUNC ((last\_call\_et - TRUNC(last\_call\_et / 3600, 0) \* 3600) / 60, 0) ) ||' MINS' 空闲时间小时分钟,  
 module 模块  
 FROM v$session s, v$process p  
 WHERE TYPE = 'USER'  
 AND p.addr = s.paddr  
 AND status != 'KILLED'  
 \-- AND SUBSTR (machine, 1, 19) NOT IN ('机器名')  
 AND last\_call\_et > 60 \* 60 \* 1-- 空闲时间超过1小时的连接  
 ORDER BY last\_call\_et desc;  
  
 select sid,username,status,  
 to\_char(logon\_time,'dd-mm-yy hh:mi:ss') "LOGON",  
 floor(last\_call\_et/3600)||':'||  
 floor(mod(last\_call\_et,3600)/60)||':'||  
 mod(mod(last\_call\_et,3600),60) "IDLE",  
 program  
 from v\_$session  
 where type='USER'  
 order by last\_call\_et;  
  
 select s.process, s.sid, t.sql\_text   
 from gv$session s, gv$sql t   
 where s.sql\_address =t.address   
 and s.sql\_hash\_value =t.hash\_value   
 \--and s.program like '%JDBC%'   
 and s.last\_call\_et > 600   
 and s.status = 'ACTIVE'

个人认为还是查清楚这些异常连接的原因，不要轻易的kill掉这些会话。  
参考文献：[http://www.weste.net/2006/8-7/11352794038.html][http_www.weste.net_2006_8-7_11352794038.html]

<table> 
 <tbody> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td align="right" style="font-family:'courier new';color:#000000;font-size:16px;"> Subject: </td> 
 <td align="left" colspan="4" style="font-family:'courier new';color:#000000;font-size:16px;"> Removing Sessions in Killed Status on Unix </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;"> &nbsp; </td> 
 <td align="right" style="font-family:'courier new';color:#000000;font-size:16px;"> <a href="https://metalink2.oracle.com/help/usaeng/Search/search.html#file" style="font-family:'courier new';color:#565656;font-size:16px;text-decoration:none;" rel="nofollow">Doc ID</a>: </td> 
 <td align="left" style="font-family:'courier new';color:#000000;font-size:16px;"> 274216.1 </td> 
 <td align="right" style="font-family:'courier new';color:#000000;font-size:16px;"> Type: </td> 
 <td align="left" style="font-family:'courier new';color:#000000;font-size:16px;"> BULLETIN </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;"> &nbsp; </td> 
 <td align="right" style="font-family:'courier new';color:#000000;font-size:16px;"> Modified Date : </td> 
 <td align="left" style="font-family:'courier new';color:#000000;font-size:16px;"> 11-NOV-2008 </td> 
 <td align="right" style="font-family:'courier new';color:#000000;font-size:16px;"> Status: </td> 
 <td align="left" style="font-family:'courier new';color:#000000;font-size:16px;"> PUBLISHED </td> 
 </tr> 
 </tbody> 
</table>

--------------------

# [v$Session详解][v_Session] #

从Oracle10gR1开始，Oracle在V$SESSION中增加关于等待事件的字段，实际上也就是把原来V$SESSION\_WAIT视图中的所有字段全部整合到了V$SESSION视图中，开始的时候我还以为ASH是依赖联合查询来获取信息的，仔细一看才发现现在V$SESSION已经发生了变化。(如果进一步研究你会发现，实际上V$SESSION的底层查询语句及X$表已经有了变化)

这一变化使得我们的查询得以简化，但是也使得V$SESSION\_WAIT开始变得多余，此外V$SESSION中还增加了BLOCKING\_SESSION等字段，以前我们需要通dba\_waiters等视图才能获得的信息，现在也可以直接从V$SESSION中得到了。既然这样，让我们好好研究V$SESSION视图中每个字段的含义。

首先，请看官方文档上面关于V$SESSION字段的说明：

v$session：This view has one row for every session connected to the database instance. The sessions include user sessions, as well as background processes like DBWR, LGWR, archiver.

1、SADDR --Session address Session地址

2、SID --Session identifier Session ID

3、SERIAL\#  
官方解释：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.  
sid 会重用，但是同一个SID被重用时，serial\#会增加，不会重复。  
比如说你在10:00时发现有一个SID 为10 ,serial\#为100的session 不正常，想杀掉他，要是直接用kill sid 10 ，而同时这个session 主动退出，新session近来 而又正好用了 10这个SID （这时新session的serial\#不会=100，只会比100高）,就会发生误杀的情况。所以Oracle要求我们在杀session时，必须同时指定sid和serial\#.  
从另外一个角度上说，sid 在同一个instance的当前session中是一个unique key, 而sid ,serial\#则是在整个instance生命期内的所有session中是unique key。（不考虑serial\#超过最大值，重用的情况）

3、AUDSID --Auditing session ID

from asktom  
the audsid column is populated via a sequence and for normal  
sessions is the same as "userenv('sessionid')" -- but for some background sessions -- it is not set  
(it comes back as "0" making the view not work.  
So, I'd just ignore "audsid" for now and use SID.

4、paddr ，这个我们要和saddr、taddr一起讲一下

saddr(session address):表示当前记录的内存地址;  
paddr(process address):该session对应的进程地址,关联v$process的addr字段,可以通过这个字段查处当前session对应操作系统的那个进程的id;  
taddr(transation address):当前有活动事务的地址,关联v$transaction表的addr,通过这个字段关联查出当前session正在使用的回滚段的情况,以及当前事务的大小等信息

5、USER\#、USERNAME 表示登录的用户名编号和用户名，比如说sytem、test等，如果没有说明是后台进程产生的session。

比如说：QMNC、MMON 、MMNL 等后台经常，这是时候我们可以看看v$session 的PROGRAM字段。

6、COMMAND Command in progress (last statement parsed); for a list of values, see[Table 7-5][]. These values also appear in the AUDIT\_ACTIONStable.

COMMAND Column of V$SESSION and Corresponding Commands

<table style="font-family:'courier new';color:#000000;font-size:16px;border:1px solid #C0C0C0;"> 
 <tbody> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> Number </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> Command </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> Number </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> Command </td> 
 </tr> 
 </tbody> 
 <tbody> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 1 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> CREATE TABLE </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 2 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> INSERT </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 3 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> SELECT </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 4 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> CREATE CLUSTER </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 5 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> ALTER CLUSTER </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 6 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> UPDATE </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 7 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> DELETE </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 8 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> DROP CLUSTER </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 9 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> CREATE INDEX </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 10 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> DROP INDEX </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 11 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> ALTER INDEX </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 12 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> DROP TABLE </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 13 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> CREATE SEQUENCE </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 14 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> ALTER SEQUENCE </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 15 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> ALTER TABLE </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 16 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> DROP SEQUENCE </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 17 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> GRANT OBJECT </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 18 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> REVOKE OBJECT </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 19 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> CREATE SYNONYM </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 20 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> DROP SYNONYM </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 21 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> CREATE VIEW </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 22 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> DROP VIEW </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 23 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> VALIDATE INDEX </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 24 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> CREATE PROCEDURE </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 25 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> ALTER PROCEDURE </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 26 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> LOCK </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 27 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> NO-OP </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 28 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> RENAME </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 29 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> COMMENT </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 30 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> AUDIT OBJECT </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 31 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> NOAUDIT OBJECT </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 32 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> CREATE DATABASE LINK </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 33 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> DROP DATABASE LINK </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 34 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> CREATE DATABASE </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 35 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> ALTER DATABASE </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 36 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> CREATE ROLLBACK SEG </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 37 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> ALTER ROLLBACK SEG </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 38 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> DROP ROLLBACK SEG </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 39 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> CREATE TABLESPACE </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 40 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> ALTER TABLESPACE </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 41 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> DROP TABLESPACE </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 42 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> ALTER SESSION </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 43 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> ALTER USER </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 44 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> COMMIT </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 45 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> ROLLBACK </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 46 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> SAVEPOINT </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 47 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> PL/SQL EXECUTE </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 48 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> SET TRANSACTION </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 49 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> ALTER SYSTEM </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 50 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> EXPLAIN </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 51 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> CREATE USER </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 52 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> CREATE ROLE </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 53 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> DROP USER </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 54 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> DROP ROLE </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 55 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> SET ROLE </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 56 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> CREATE SCHEMA </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 57 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> CREATE CONTROL FILE </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 59 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> CREATE TRIGGER </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 60 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> ALTER TRIGGER </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 61 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> DROP TRIGGER </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 62 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> ANALYZE TABLE </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 63 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> ANALYZE INDEX </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 64 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> ANALYZE CLUSTER </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 65 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> CREATE PROFILE </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 66 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> DROP PROFILE </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 67 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> ALTER PROFILE </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 68 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> DROP PROCEDURE </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 70 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> ALTER RESOURCE COST </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 71 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> CREATE MATERIALIZED VIEW LOG </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 72 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> ALTER MATERIALIZED VIEW LOG </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 73 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> DROP MATERIALIZED VIEW LOG </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 74 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> CREATE MATERIALIZED VIEW </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 75 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> ALTER MATERIALIZED VIEW </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 76 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> DROP MATERIALIZED VIEW </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 77 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> CREATE TYPE </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 78 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> DROP TYPE </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 79 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> ALTER ROLE </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 80 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> ALTER TYPE </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 81 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> CREATE TYPE BODY </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 82 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> ALTER TYPE BODY </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 83 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> DROP TYPE BODY </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 84 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> DROP LIBRARY </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 85 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> TRUNCATE TABLE </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 86 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> TRUNCATE CLUSTER </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 91 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> CREATE FUNCTION </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 92 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> ALTER FUNCTION </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 93 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> DROP FUNCTION </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 94 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> CREATE PACKAGE </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 95 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> ALTER PACKAGE </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 96 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> DROP PACKAGE </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 97 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> CREATE PACKAGE BODY </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 98 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> ALTER PACKAGE BODY </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 99 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> DROP PACKAGE BODY </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 100 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> LOGON </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 101 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> LOGOFF </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 102 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> LOGOFF BY CLEANUP </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 103 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> SESSION REC </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 104 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> SYSTEM AUDIT </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 105 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> SYSTEM NOAUDIT </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 106 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> AUDIT DEFAULT </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 107 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> NOAUDIT DEFAULT </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 108 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> SYSTEM GRANT </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 109 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> SYSTEM REVOKE </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 110 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> CREATE PUBLIC SYNONYM </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 111 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> DROP PUBLIC SYNONYM </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 112 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> CREATE PUBLIC DATABASE LINK </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 113 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> DROP PUBLIC DATABASE LINK </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 114 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> GRANT ROLE </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 115 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> REVOKE ROLE </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 116 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> EXECUTE PROCEDURE </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 117 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> USER COMMENT </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 118 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> ENABLE TRIGGER </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 119 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> DISABLE TRIGGER </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 120 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> ENABLE ALL TRIGGERS </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 121 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> DISABLE ALL TRIGGERS </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 122 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> NETWORK ERROR </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 123 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> EXECUTE TYPE </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 157 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> CREATE DIRECTORY </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 158 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> DROP DIRECTORY </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 159 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> CREATE LIBRARY </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 160 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> CREATE JAVA </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 161 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> ALTER JAVA </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 162 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> DROP JAVA </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 163 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> CREATE OPERATOR </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 164 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> CREATE INDEXTYPE </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 165 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> DROP INDEXTYPE </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 167 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> DROP OPERATOR </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 168 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> ASSOCIATE STATISTICS </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 169 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> DISASSOCIATE STATISTICS </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 170 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> CALL METHOD </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 171 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> CREATE SUMMARY </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 172 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> ALTER SUMMARY </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 173 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> DROP SUMMARY </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 174 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> CREATE DIMENSION </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 175 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> ALTER DIMENSION </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 176 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> DROP DIMENSION </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 177 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> CREATE CONTEXT </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 178 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> DROP CONTEXT </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 179 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> ALTER OUTLINE </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 180 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> CREATE OUTLINE </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 181 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> DROP OUTLINE </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 182 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> UPDATE INDEXES </td> 
 </tr> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> 183 </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> ALTER OPERATOR </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> </td> 
 <td style="font-family:'courier new';color:#454545;font-size:16px;border:1px solid #C0C0C0;border-collapse:collapse;"> </td> 
 </tr> 
 </tbody> 
</table>

7、OWNERID

如果值为2147483644，则此列的内容无效。否则此列包含拥有可移植会话的用户标符。对于利用并行从服务器的操作，将这个值解释为一个48 字节的值。其低位两字节表示会话号，而高位字节表示查询协调程序的实例ID

8、LOCKWAIT Address of lock waiting for; null if none

等待锁的地址；如果没有，为NULL

9、STATUS

Status of the session:

*  ACTIVE - Session currently executing SQL
 *  INACTIVE
 *  KILLED - Session marked to be killed
 *  CACHED - Session temporarily cached for use by Oracle\*XA
 *  SNIPED - Session inactive, waiting on the client

文档里面已经说的比较清楚了

10、SERVER

服务器类型：DEDICATED（独有）、SHARED（共享）、PSEUDO、NONE

服务器类型在安装时候已经选择了，我们一般选择DEDICATED模式，非共享。

11、SCHEMA\# 模式用户标识符

12、SCHEMANANME 模式用户名、OSUSER 操作系统客户机用户

13、PROCESS 操作系统客户机进程ID

关于v$process与v$session中process的理解  
  
说明  
v$session有个process字段，V$PROCESS有个SPID字段，这两个字段是不是一个意思呢？是不是都代表会话的操作系统进程呢？  
官方文档上的解释：  
SPID VARCHAR2(12) Operating system process identifier  
PROCESS VARCHAR2(9) Operating system client process ID  
  
本文以数据库服务器安装在linux上为例进行说明。  
V$PROCESS中的SPID表示的是操作系统的进程，v$session中的process表示客户端进程ID，即客户端进程在客户端机器上的进程ID号。一个表示客户端进程在客户端机器上的进程号，一个表示服务器进程在服务器上的进程号。  
连接服务器的会话，发起会话的客户端进程可能是unix进程，也可能是windows进程。  
\-------------------  
windows客户端进程  
\-------------------  
例如，使用windows进程连接unix上的数据库，对应会话sid=35，对应客户端windows的988:5412

今天有朋友问到V$SESSION中的PROCESS是啥意思，联机文档的解释如下：

<table style="font-family:'courier new';color:#666666;font-size:16px;background:#FFFFFF;"> 
 <tbody> 
 <tr style="font-size:10pt;text-align:left;vertical-align:top;border-width:.5pt;border-style:solid;border-color:#000000;font-family:'courier new';"> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;"> PROCESS </td> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;"> VARCHAR2(24) </td> 
 <td style="font-family:'courier new';color:#000000;font-size:16px;"> Operating system client process ID </td> 
 </tr> 
 </tbody> 
</table>

操作系统的客户端进程ID。

但是如果我们查看PROCESS列，会发现并不像文档解释的那么明确，

这个列有2个数字组成，中间用:分割，

我们从WINDOWS 用SQLPLUS登陆到数据库中，然后查询PROCESS字段，就很容易发现：前面的数字是客户端进程的ID号。

C:\\Documents and Settings\\htaix>sqlplus scott/tiger@testdb

SQL\*Plus: Release 10.2.0.1.0 - Production on 星期三 12月 12 10:48:33 2012

连接到:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, OLAP, Data Mining

and Real Application Testing options

SQL> select process

2 from v$session where username='SCOTT';

PROCESS

\------------------------

**14612:4716**

从WINDOWS的任务管理器就很容易发现14612是sqlplus的进程ID，

[![img\_44af0ef8326e27ae4d00f0384e815dd2.jpg][img_44af0ef8326e27ae4d00f0384e815dd2.jpg]][img_44af0ef8326e27ae4d00f0384e815dd2.jpg]

那么4716是啥呢？

4716其实是SQLPLUS的线程ID，通过任务管理器是看不到这个号的。

为此我写了一个简单的小程序，用于获取指定进程号的线程ID列表：

输入上面的进程ID就可以看到进程14612的线程ID是4716.

[![img\_6b0e9e82d14f2cdefbd871148527141a.jpg][img_6b0e9e82d14f2cdefbd871148527141a.jpg]][img_6b0e9e82d14f2cdefbd871148527141a.jpg]

程序采用DELPHI编写，源码如下，有兴趣的朋友可以试试：

**unit Unit1;**

**interface**

**uses**

**Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,**

**Dialogs, StdCtrls;**

**type**

**TForm1 = class(TForm)**

**Button2: TButton;**

**Edit1: TEdit;**

**Label1: TLabel;**

**memo1: TMemo;**

**procedure Button2Click(Sender: TObject);**

**private**

**\{ Private declarations \}**

**public**

**\{ Public declarations \}**

**end;**

**var**

**Form1: TForm1;**

**implementation**

**\{$R \*.dfm\}**

**uses TlHelp32;**

**procedure TForm1.Button2Click(Sender: TObject);**

**var**

**FProcessEntry32: TProcessEntry32;**

**ProcessID: DWord;**

**ThreadHandle: THandle;**

**ThreadStruct: TThreadEntry32;**

**begin**

**ProcessID:= strtoint(edit1.Text);**

**ThreadHandle := CreateToolHelp32Snapshot(TH32CS\_SnapThread,ProcessID);**

**try**

**ThreadStruct.dwSize := sizeOf(TThreadEntry32);**

**if Thread32First(ThreadHandle, ThreadStruct) then**

**repeat**

**if ThreadStruct.th32OwnerProcessID = ProcessID then**

**Memo1.Lines.Add(IntTostr(ThreadStruct.th32ThreadID));**

**until not Thread32Next(ThreadHandle, ThreadStruct);**

**finally**

**CloseHandle(ThreadHandle)**

**end;**

**end.**

14、MACHINE 操作系统机器名、TERMINAL 操作系统终端名

可以根据主terminal查询客户端的ip

select utl\_inaddr.get\_host\_address(terminal) from v$session where username is not null;

15、PROGRAM 操作系统程序名

通过本机连接的session，一般都有program。如果是通过服务器连接的session，一般都没有program。

16、TYPE 会话类型

一般有两个类型：background（后台进程）、user（用户）

17、SQL\_ADDRESS

Used with SQL\_HASH\_VALUE to identify the SQL statement that is currently being executed  
当前正在执行的SQL语句的SQL\_HASH\_VALUE值  
  
18、SQL\_HASH\_VALUE

Used with SQL\_ADDRESS to identify the SQL statement that is currently being executed  
当前正在执行的SQL语句的SQL\_ADDRESS值  
SQL\_HASH\_VALUE，SQL\_ADDRESS：这两列用于鉴别默认被session执行的SQL语句。如果为null或0，那就说明这个session没有执行任何SQL语句。PREV\_HASH\_VALUE和PREV\_ADDRESS两列用来鉴别被session执行的上一条语句。

19、SQL\_ID

SQL identifier of the SQL statement that is currently being executed  
正在执行的SQL语句的标识符

20、SQL\_CHILD\_NUMBER

Child number of the SQL statement that is currently being executed

21、PREV\_SQL\_ADDR

Used with PREV\_HASH\_VALUE to identify the last SQL statement executed

22、PREV\_HASH\_VALUE

Used with SQL\_HASH\_VALUE to identify the last SQL statement executed

23、MODULE、ACTION

Name of the currently executing module as set by calling the DBMS\_APPLICATION\_INFO.SET\_MODULE procedure

1.  
2.  > 
3.  
4.  
5.  
6.  
7.  
8.  > 
9.  
10. 
11. 
12. 
13. 
14. 
15. 
16. 
17. 
18. 
19. 
20. 
21. > 
22. 
23. 
24. 
25. 
26. 
27. 
28. 
29. 
30. 
31. 
32. 
33. 
34. > 
35. 
36. 
37. 
38. 
39. 
40. 
41. 
42. 
43. 
44. 
45. 
46. 
47. > 
48. 
49. 
50. 
51. > 
52. 
53. 
54. 
55. 
56. 
57. > 
58. 
59. 
60. 
61. 
62. 
63. > 
64. 
65. 
66. 
67. 
68. 
69. > 
70. 
71. 
72. 
73.

1.  > 
2.  
3.  
4.  
5.  
6.  
7.  
8.  
9.  
10.

1.  
2.  > 
3.  
4.  
5.  
6.  
7.

1.  > 
2.  
3.  > 
4.  
5.  
6.  
7.  
8.  
9.  > 
10. 
11. 
12. 
13. 
14. 
15. > 
16. 
17. 
18. 
19.

>  
  
  
  
  
  
  
  
  
  
  
  
>

> 
 
 
 
 
 
 
 
< 
>

>   
>

--------------------

> <table style="line-height:1.6;margin-left:-6.3pt;border-collapse:collapse;color:#666667;font-family:'courier new';"> 
> <tbody style="margin-left:-6.3pt;color:#666667;font-family:'courier new';"> 
> <tr style="margin-left:-6.3pt;color:#666667;font-family:'courier new';"> 
> <td style="background:#c7daf1;color:#666667;font-family:'courier new';"> <a style="font-size:11pt;color:#0000FA;" href="http://blog.itpub.net/26736162/abstract/1/" rel="nofollow"></a><a style="font-size:11pt;color:#0000FA;" href="http://www.cnblogs.com/lhrbest" rel="nofollow"></a><a style="font-size:11pt;color:#0000FA;" href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&amp;mid=307287619&amp;idx=1&amp;sn=9149fab6ae1aecfd1288316c5edc3805&amp;scene=19#wechat_redirect" rel="nofollow"></a> <a style="font-size:11pt;color:#0000FA;" href="http://blog.itpub.net/26736162/abstract/1/" rel="nofollow"></a> <a style="font-size:11pt;color:#0000FA;" href="http://www.cnblogs.com/lhrbest" rel="nofollow"></a> <a style="font-size:11pt;color:#0000FA;" href="http://blog.itpub.net/26736162/viewspace-1624453/" rel="nofollow"></a> <a style="font-size:11pt;color:#0000FA;" href="http://blog.itpub.net/26736162/viewspace-2134706/" rel="nofollow"></a> <a style="font-size:11pt;color:#0000FA;" href="http://www.toutiao.com/c/user/6401772890/#mid=1564638659405826" rel="nofollow"></a> <a style="font-family:'courier new';line-height:1.6;color:#0000FA;font-size:11pt;" href="https://weidian.com/s/793741433?wfr=c&amp;ifr=shopdetail%20" rel="nofollow">&amp;</a> <a style="font-family:'courier new';line-height:1.6;color:#0000FA;font-size:11pt;" href="http://blog.itpub.net/26736162/viewspace-2142121/" rel="nofollow"></a> <a style="font-size:11pt;color:#0000FA;" href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&amp;mid=307287619&amp;idx=1&amp;sn=9149fab6ae1aecfd1288316c5edc3805&amp;scene=19#wechat_redirect" rel="nofollow"></a> <img src="https://yqfile.alicdn.com/img_96191d69621dcd29c177263b139ac676.jpg" width="200" height="200" alt=""><img src="https://yqfile.alicdn.com/img_7ad73bd84c95217601f0698908a39718.png" width="200" height="200" alt=""><img src="https://yqfile.alicdn.com/img_2309a9ce8f64a9d85fc1d39e1d4e8f5d.png" width="200" height="200" alt=""><img src="https://yqfile.alicdn.com/img_7af0b3716946bda503af9b5692aab870.png" width="200" height="200" alt=""> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </td> 
> </tr> 
> </tbody> 
> </table>
> 
> <table style="font-family:'Courier New';color:#666667;width:360px;border-style:none;"> 
> <tbody> 
> <tr style="font-family:'Courier New';color:#666667;font-size:10pt;text-align:center;width:100px;"> 
> <td style="font-family:'Courier New';color:#666667;font-size:10pt;width:120px;"> <a href="http://mail.qq.com/cgi-bin/qm_share?t=qm_mailme&amp;email=eRURCxscCg05CAhXGhYU" style="font-family:'Courier New';color:#666667;text-decoration:none;" rel="nofollow"><img src="https://yqfile.alicdn.com/img_e3029f287d989cd04bd75432ecc1c172.png" alt="img_e3029f287d989cd04bd75432ecc1c172.png"></a> </td> 
> <td style="font-family:'Courier New';color:#666667;font-size:10pt;width:120px;"> <a style="font-family:'Courier New';color:#666667;" rel="nofollow"><img alt="DBA笔试面试讲解群1" title="DBA笔试面试讲解群1"></a> </td> 
> <td style="font-family:'Courier New';color:#666667;font-size:10pt;width:120px;"> <a rel="nofollow"><img alt="DBA笔试面试讲解群2" title="DBA笔试面试讲解群2"></a> </td> 
> <td style="font-family:'Courier New';color:#666667;font-size:10pt;width:120px;"><a href="http://wpa.qq.com/msgrd?v=3&amp;uin=646634621&amp;site=qq&amp;menu=yes" style="font-family:'Courier New';color:#666667;" rel="nofollow"><img src="http://wpa.qq.com/pa?p=2:646634621:41%20&amp;r=0.30709030851721764" alt="欢迎与我联系" title="欢迎与我联系"></a></td> 
> </tr> 
> </tbody> 
> </table>

[Oracle 11g_v_session_server]: http://blog.itpub.net/26736162/viewspace-2138277/
[Oracle 11g_v_session_server 1]: http://blog.itpub.net/30162081/viewspace-1984944/
[hoegh]: http://blog.itpub.net/30162081/
[v_session_LAST_CALL_ET]: http://blog.itpub.net/26736162/viewspace-1762403/
[v_session_LAST_CALL_ET 1]: http://blog.itpub.net/9252210/viewspace-594290/
[zhanglei_itput]: http://blog.itpub.net/9252210/
[system_oracle_devdb2]: mailto:system/oracle@devdb2
[http_www.weste.net_2006_8-7_11352794038.html]: http://www.weste.net/2006/8-7/11352794038.html
[v_Session]: http://www.cnblogs.com/shengs/p/4895085.html
[Table 7-5]: http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_2088.htm#g1432037
[img_44af0ef8326e27ae4d00f0384e815dd2.jpg]: /images/20220131/5a6e910bfe8c43649a413f643c056a3d.png
[img_6b0e9e82d14f2cdefbd871148527141a.jpg]: /images/20220131/583c48c74dbf441896a4e54d9fa38fb1.png