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,
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