Negative ROW_WAIT_OBJ#

  • From: Rakesh Ra <rakeshra.tr@xxxxxxxxx>
  • To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 3 Jan 2020 19:01:59 +0530

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 01-2020