Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: How do we shrink UNDO tbs in 9i ?
In a busy system the following query helps
SQL> column start_scn format 99999999999999; SQL> select STATUS,XIDUSN,USED_UBLK,USED_UREC,START_TIME,START_SCN from v$transaction;
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 21 2007 - 13:16:53 CST
![]() |
![]() |