-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|