That looks like a 32 bit rollover relating to something like a global temporary
table generated by a CTE ("with" subquery).
Regards
Jonathan Lewis
________________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on behalf
of Rakesh Ra <rakeshra.tr@xxxxxxxxx>
Sent: 03 January 2020 13:31
To: Oracle-L Freelists
Cc: Rakesh RA
Subject: Negative ROW_WAIT_OBJ#
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
--
//www.freelists.org/webpage/oracle-l