Multiple choice technology databases

Which dictionary view or views should be monitored to determine how long users are waiting for dispatchers?

  1. V$SESSTAT
  2. V$QUEUE
  3. V$SHARED_SERVER
  4. V$VIEW
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

V$QUEUE is the Oracle dynamic performance view that monitors dispatcher queue statistics, including wait times. V$SESSTAT shows session statistics, V$SHARED_SERVER shows shared server status, and V$VIEW is not a valid view for monitoring dispatcher wait times.

Keep practicing — related questions