RE: Enqueue TX level 4 wait -- blocks dump -- Real Time case
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 4 May 2004 13:48:03 -0400
Why not just look in v$transaction where the rbs information for segment,
slot, and sequence is broken out for you? v$transaction.addr =
v$session.taddr
HTH -- Mark D Powell --
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Diego Cutrone
Sent: Monday, May 03, 2004 8:39 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Enqueue TX level 4 wait -- blocks dump -- Real Time case
Thank you Jonathan.
I changed the approach.
I started looking for this wait in realtime and I found it. As a matter of
fact it's still there andit seems it will be here for a while.
V$SESSION_WAIT
SQL> /
SID SEQ# EVENT
--------- --------- --------------------------------------------------------
--------
P1TEXT P1
P1RAW
---------------------------------------------------------------- --------- -
---------------
P2TEXT P2
P2RAW
---------------------------------------------------------------- --------- -
---------------
P3TEXT P3
P3RAW
---------------------------------------------------------------- --------- -
---------------
WAIT_TIME SECONDS_IN_WAIT STATE
--------- --------------- -------------------
112 49732 enqueue
name|mode 1.415E+09
0000000054580006
id1 196661
0000000000030035
id2 514403
000000000007D963
0 8614 WAITING
121 49454 enqueue
name|mode 1.415E+09
0000000054580004
id1 1114137
0000000000110019
id2 17942
0000000000004616
0 6072 WAITING
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
