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.
What could be the problem in this database?
A.
Java pool is not configured.
B.
The CPU in the system is slow.
C.
The shared pool size is inadequate.
D.
The database buffer cache is inadequate.
E.
The OPEN_CURSORS parameter is set to a small value.
The answer is C because the DB high parsing
C is right. as there are very high percentage of misses.
They probably want you to answer C, but I’d say the issue lies with the amount of new cursors open per sec, this makes the DB constantly change the library cache memory structures, which produce those latch and mutex waits… might partially hide it with a larger shared pool.