Re: Negative ROW_WAIT_OBJ#

You can always check v$session_wait. Since the event is scattered read, the event arguments will be the file id, block# and the number of blocks to read. You can then for out the object# from dba_extents. The session view wouldn't be my first choice for investigating such events.

On Fri, Jan 3, 2020, 08:32 Rakesh Ra <rakeshra.tr_at_gmail.com> wrote:

> 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