Negative ROW_WAIT_OBJ#

From: Rakesh Ra <rakeshra.tr_at_gmail.com>
Date: Fri, 3 Jan 2020 19:01:59 +0530
Message-ID: <CAOGpvWoHVOs4uYXKoPQYLb7tV4tvQcqup0-JFGqr5Vq=2O7mfQ_at_mail.gmail.com>



Hi Listers,

I am monitoring one of the SQL session which is having a long running SQL . In order to identify the object in wait I am using the below SQl against v$session and I am getting a negative obj#. What does this mean? Can someone

select sid,serial#,event,ROW_WAIT_OBJ#,status,seq#,seconds_in_wait from v$session where sid=400;

  SID    SERIAL# EVENT                                ROW_WAIT_OBJ# STATUS
        SEQ# SECONDS_IN_WAIT

---------- ---------- ------------------------------------ -------------
-------- ---------- ---------------
400 16615 db file scattered read -40002177 ACTIVE 497 25

BR,
RRA
--

http://www.freelists.org/webpage/oracle-l Received on Fri Jan 03 2020 - 14:31:59 CET

Original text of this message