Re: How do we shrink UNDO tbs in 9i ?

  • From: GovindanK <gkatteri@xxxxxxxxx>
  • To: oratips@xxxxxxxxx
  • Date: Wed, 21 Nov 2007 11:16:53 -0800

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; 


--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 11-2007