| Rollback Segments [message #217875] |
Mon, 05 February 2007 23:20 |
M.Shakeel Azeem
Messages: 226
Registered: September 2006
|
Senior Member |
|
|
oracle 8.1.7.0.0
SQL> select class,count
2 from v$waitstat
3 where class like 'undo%'
4 ;
CLASS COUNT
------------------ ----------
undo header 12031
undo block 371
i have read a document which describes
Undo header Contention on undo segment header
If you are not using automatic undo management then add more rollback segments
Undo Block Contention on undo segment block
Increase the size of rollback segment if you are not using automatic undo management
Can anybody help me in this regard?
thanks in advance
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
