You work as a DBA for a company and you have the responsibility of managing one of its online
transaction processing (OLTP) systems. The database encountered performance-related
problems and you generated an Automatic Workload Repository (AWR) report to investigate it further.
View the Exhibits and examine the AWR report.
Which is the appropriate solution to the problem in this database?
A.
increasing the size of the shared pool
B.
adding one more CPU to the system
C.
setting the CURSOR_SHARING parameter to EXACT
D.
configuring Java pool because it is not configured
A is right. mutex X pin S wait on X
B is wrong. not CPU
C is wrong.
D is wrong.
So A is correct