Re: no rollback ??

Nothing in v$transaction?

Does the query below return nothing as well?

select s.osuser


      ,s.username

      ,s.sid

      ,r.segment_name

      ,t.space

      ,t.recursive

      ,t.noundo

      ,t.used_ublk

      ,t.used_urec

      ,t.log_io

      ,t.phy_io

      ,substr(sa.sql_text,1,200) txt

from v$session s,
     v$transaction t,
     dba_rollback_segs r,
     v$sqlarea sa
where s.taddr=t.addr
and   t.xidusn=r.segment_id(+)
and   s.sql_address=sa.address(+)
/

"AK" <oramagic_at_hotmail.com>
Sent by: ml-errors_at_fatcity.com
 08/25/2003 03:49 PM
 Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        no rollback ??

There is one log running process in db here and I waiting for it to finish since last 3 hours. when I see sql_address in v$session for this session and then find sql in v$sqlarea its a update statement . But then there is no entry in v$transaction . How'z it possible that there no rollback entry for one update statement ??  

-ak  

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: Jared.Still_at_radisys.com

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: ListGuru_at_fatcity.com (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).