Home » RDBMS Server » Server Administration » Rollback Segments
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

Previous Topic: Datafile Size
Next Topic: How to Export query result to csv file
Goto Forum:
  


Current Time: Wed Dec 04 19:52:44 CST 2024