• Description: Performance Tuning
• Passing Score: 75%
• Practice Test - Number of questions: 156 questions
• Simulation Test - Number of questions: 156 questions
• Simulation Test Duration: 90 minutes
• Has explanations: No

Answer(s)

1. monitoring the Shared Server environment, you decided to increase the number of SharedServers available for use by the database by increasing the value of the initialization parameterMAX_SHARED_SERVERS. Which condition requires this change in the parameter value?A. The number of rows in the V$CIRCUIT view is equal to the value of theSHARED_SERVER_SESSIONS parameter.
2. The V$SHARED_SERVER_MONITOR view shows a high value for theSERVERS_STARTED column.
3. The V$QUEUE view shows an increasing number of requests in the queue and the value ofWAIT column is increasing.
4. The V$SHARED_SERVER_MONITOR view shows that the value of theSERVERS_STARTED column is equal to the value of the MAX_SHARED_SERVERSparameter.

The V$QUEUE view shows an increasing number of requests in the queue and the value ofWAIT column is increasing.