When you query the v$waitstat, what are some of output that one should pay a close attention to? In a nutshell,how do you rectify them
Printable View
When you query the v$waitstat, what are some of output that one should pay a close attention to? In a nutshell,how do you rectify them
Hi,
This is used to prevent rollback segment contention between user processes,the following query display the number of waits since startup
select class,count from v$waitstat where class like '%undo%'
Any non zero value in the count column indicates rollback header contention
v$waitstat shows the waits for data blocks, in other words block contention, not just RBS