Re: Negative ROW_WAIT_OBJ#

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 3 Jan 2020 13:42:39 +0000
Message-ID: <LO2P265MB1551F0B867E26645887A0D4EA5230_at_LO2P265MB1551.GBRP265.PROD.OUTLOOK.COM>

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_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Rakesh Ra <rakeshra.tr_at_gmail.com> 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
--

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