RE: Enqueue TX level 4 wait -- blocks dump -- Real Time case

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Tue, 4 May 2004 13:48:03 -0400
Message-ID: <564DE4477544D411AD2C00508BDF0B6A1CE0AB0B@usahm018.exmi01.exch.eds.com>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Diego Cutrone Sent: Monday, May 03, 2004 8:39 PM
To: oracle-l_at_freelists.org
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_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


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

Received on Tue May 04 2004 - 12:48:47 CDT