HomePage – TimeLine Layout

 

 

 

Undo Related Queries Part 2

List of All active Transactions   select  sid,username, t.used_ublk ,t.used_urec from v$transaction t,v$session s where   t.addr=s.taddr;   To list all Datafile of UndoTablespace   select tablespace_name,file_name,file_id,autoextensible,bytes/1048576 Mbytes, maxbytes/1048576 maxMbytes from dba_data_files where tablespace_name like …

Read More »