Re: is a process/session rolling back ?

Try this URL in Ask Tom.

http://asktom.oracle.com/pls/ask/f?p=4950:8:351991518725722326::NO::F4950_P8 _DISPLAYID,F4950_P8_CRITERIA:7143624535091, HTH. Arup
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, June 25, 2003 11:04 PM

> Hi DBAs,
>
> Can somebody confirm that the statement I am using is
> correct or not ?
>
> I use v$sess_io, v$session to check for rolling back
> of a session .(I check for consistent gets, consistent
> reads.)
>
> If the values are changing in the select, i assume
> that the session is using rbs.
>
> but is this correct process toknow that the session is
> rolling back ?
>
> Thanks and Regards,
> srinivas
>
> __________________________________
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: kommareddy sreenivasa
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arup Nanda
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).