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
