|
-
I use spotlight to monitor the database, I see buffer busy waits a lot of times and I want to find out which table it is occurring in. But I am not able to see any buffer busy waits in v$session_wait (to get the hot block). It appears in v$system_event and v$session_event but never in v$session_wait. How do I find out which is the block for which there are large number of waits.
Thanx
KN
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
|