V$SHAREDSERVERMONITOR - Definition - Managing Oracle Database Processes

Q.  What contains information for tuning shared server in a Monitoring Shared Server?
- Published on 28 Jul 15

a. V$SHARED_SERVER
b. V$CIRCUIT
c. V$SHARED_SERVER_MONITOR
d. V$SHARED_POOL_RESERVED

ANSWER: V$SHARED_SERVER_MONITOR
 

    Discussion

  • Nirja Shah   -Posted on 23 Sep 15
    - The following views are useful for obtaining information about your shared server configuration and for monitoring performance.

    - V$SHARED_SERVER - Contains information on the shared servers.

    - V$CIRCUIT - Contains information about virtual circuits, which are user connections to the database through dispatchers and servers.

    - V$SHARED_SERVER_MONITOR - Contains information for tuning shared server.

    - V$SHARED_POOL_RESERVED - Lists statistics to help tune the reserved pool and space within the shared pool.

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)