-
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
-
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]
-
Depends, how long has your instance been up? If it has been up 20 days, then this is relatively low contention.
