Buffer waits

[pthomas]

if I do a query such as


select
w.class block_class,
w.count total_waits,
w.time time_waited
from
sys.v_$waitstat w
where
w.count > 0
order by 3 desc
/

I get this result ?

SQL> @buffer_busywaits.sql

BLOCK_CLASS TOTAL_WAITS TIME_WAITED
------------------------------ ----------- -----------
undo header 39 116
data block 1 0
undo block 8 0

3 rows selected.


Could you suggest which factor I need to cconsider to reduce the waits.

Thanks

[Sweetie]

Hi

I think you are facing Rollback Segment contention, may be you could create another RBS tablespace in another disk and create rbs in that new tablespace

[Edited by Sweetie on 01-23-2001 at 09:58 AM]

[marist89]

Depends, how long has your instance been up? If it has been up 20 days, then this is relatively low contention.