A doubt in 9.0.1.0.0 database..

From: Arul kumar <rakumar_at_mahindrabt.com>
Date: Thu, 14 Feb 2002 00:10:35 -0800
Message-ID: <F001.0040F1C5.20020213235820@fatcity.com>

Hi DBAs,
I got a problem in Rollback Segments..
This is the setting for UNDO ( Rollback ) in my init file...

undo_management=AUTO
undo_retention=900
undo_suppress_errors=FALSE
undo_tablespace=UNDOTBS

While querying V$waitstat, got the foll. :

CLASS                   
COUNT                    

TIME
system undo header           

0                       

0
system undo block             

0                       

0

undo header                 
312                     

64

undo block                        
1                     

32
The entry for "undo header" indicates Undo Header contention for rollback.. Right ?
Since it is "AUTO" managed, how do i tune ?? I have chk  the space usage of the tablespace, it is fairly enough free
space...
Any suggestions / tips ?
Thank You.
regards,
Arul.

---

Disclaimer

This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited.

---

Visit us at http://www.mahindrabt.com Received on Thu Feb 14 2002 - 02:10:35 CST