Oracle
1Z0-054 · Question #62
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…
The correct answer is A. increasing the size of the shared pool. See the full explanation below for the reasoning.
Question
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?
Exhibits
Options
- Aincreasing the size of the shared pool
- Badding one more CPU to the system
- Csetting the CURSOR_SHARING parameter to EXACT
- Dconfiguring Java pool because it is not configured
How the community answered
(41 responses)- A71% (29)
- B17% (7)
- C7% (3)
- D5% (2)
Community Discussion
No community discussion yet for this question.