v$waitstat
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: v$waitstat

  1. #1
    Join Date
    Jan 2001
    Posts
    72

    Thumbs down

    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



  2. #2
    Join Date
    Mar 2000
    Location
    india
    Posts
    54
    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

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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
  •  


Click Here to Expand Forum to Full Width