Monday, 7 September 2009

Performance Tuning - Question 060.

Which of these views can you use to monitor usage of Oracle Shared server processes?

A. V$SHARED_SERVER_MONITOR

B . V$SHARED_SERVERS

C . V$SHARED_PROCESSES

D . V$SS_PROCESSES

Explanation:

Answer A: The V$SHARED_SERVER_MONITOR view is a good starting point for monitoring Shared Server processes. It indicates general statistics for Shared Server processes and high water marks. Columns include: MAXIMUM_CONNECTIONS, MAXIMUM_SERVERS, MAXIMUM_SESSIONS, SERVERS_STARTED, SERVERS_TERMINATED, and SERVERS_HIGHWATER.

No comments:

Post a Comment