未知都是已知的: V$Session

V$Session_LONGOPS

作者:Fenng
出处:http://www.dbanotes.net
日期:April 27, 2005

« Tom 的 Expert one on one 的一个Bug | Blog首页 | Quest 收购 Imceda »

这个视图的来源大致是这样的:

SELECT inst_id, ksulosno, ksulosrn, ksulopna, ksulotna, ksulotde, ksulosfr,
       ksulotot, ksulouni,
       TO_DATE (ksulostm, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
       TO_DATE (ksulolut, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
       DECODE (SIGN (ksulotot - ksulosfr),
               -1, TO_NUMBER (NULL),
               DECODE (ksulosfr,
                       0, TO_NUMBER (NULL),
                       ROUND (ksuloetm * ((ksulotot - ksulosfr) / ksulosfr))
                      )
              ),
       ksuloetm, ksuloctx, ksulomsg, ksulounm, ksulosql, ksulosqh, ksuloqid
  FROM x$ksulop

对于监控长时间运行的事务还是很有用的.还有点内容,整理之后再加上来吧......

Posted by Fenng at April 27, 2005 12:22 PM
Last updated at 06:18 PM on August 20, 2005

相关文章：

世上本无事，庸人自扰之 - Jul 20, 2005
Oracle Trace Level Event Numbers - May 06, 2005
Tom 的 Expert one on one 的一个Bug - Apr 23, 2005

Trackback Pings

TrackBack URL for this entry:
http://www.dbanotes.net/mt/mt-tb.cgi/172