Multiple choice

The database is set up to run Multithreaded Server. Which view would show contention for server processes?

  1. V$CIRCUIT
  2. V$SESSION

  3. DBA_USERS
  4. V$QUEUE
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In Multithreaded Server (MTS) architecture, V$QUEUE displays contention statistics for dispatcher queues, showing if requests are waiting for server processes. V$CIRCUIT shows virtual circuit information. V$SESSION shows session information but not server process contention. DBA_USERS lists database users, not server contention. V$QUEUE is specifically designed to monitor MTS dispatcher queue performance.

Keep practicing — related questions