OCA OCP Oracle Certification Exam Braindumps

171. You recently implemented Shared Server with the default values for  MAX_SHARED_SERVERS and MAX_DISPATCHERS parameter. You observe that the value for MAX_SHARED_SERVERS parameter needs to be increased because of increased server load. Which three factors would you consider to set the optimal value for this parameter? (Choose three.)
A.the size of UGA
B.the amount of space allocated to large pool
C.the number of active concurrent user sessions
D.the amount of space consumed by each server process
E.the value of SERVERS_STARTED column of V$SHARED_SERVER_MONITOR view

ANSWER: BCD

172. You executed the following command: For the process 00, the wait column shows a significant increase in the value. Identify two possible solutions for this. (Choose two.)
A. implement connection pooling
B.increase the number of dispatchers
C.increase the value of the MAX_SHARED_SERVERS parameter
D.check the system memory capacity; a low system memory can cause the Shared Servers to run out of memory

ANSWER: CD

173. You use the following query to monitor the Shared Servers: With every execution, you observe that the values of the STARTED and TERMINATED columns are growing quickly. What action would you take?
A.The number of Shared Server sessions is too high, so you should    decrease the value of SHARED_SERVER_SESSIONS.
B.The number of Shared Servers is too high, so you should decrease the number of Shared Servers.
C.No action is required because this growth is a normal behavior in a Shared Server environment.
D.The number of Shared Servers is too low, so you should increase the number of Shared Servers.

ANSWER: D

174. After monitoring the Shared Server environment, you decided to   increase the number of Shared Servers available for use by the database by increasing the value of the initialization parameter MAX_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 the   SHARED_SERVER_SESSIONS parameter.
B.The V$SHARED_SERVER_MONITOR view shows a high value for the SERVERS_STARTED column.
C.The V$QUEUE view shows an increasing number of requests in the queue and the value of WAIT column is increasing.
D.The V$SHARED_SERVER_MONITOR view shows that the value of the   SERVERS_STARTED column is equal to the value of the MAX_SHARED_SERVERS parameter.

ANSWER: C

175. You execute the following query to diagnose the performance of the shared servers: What can you deduce from this result?
A.The user assigned to the shared server S000 is waiting for a lock resource.
B.The user assigned to the shared server S000 is holding a lock on a resource.
C.The user assigned to shared servers S001 and S003 is waiting for a lock resource.
D.The user assigned to the shared server S002 is waiting for a lock resource to be received.

ANSWER: A