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" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED] 08/25/2003 03:49 PM
|
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 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