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

SQL> select class,count
2 from v$waitstat
3 where class like 'undo%'
4 ;

------------------ ----------
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: Sat Oct 22 04:03:00 CDT 2016

Total time taken to generate the page: 0.11211 seconds