Oracle
1Z0-054 · Question #4
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 C. The shared pool size is inadequate. 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. What could be the problem in this database?
Exhibits
Options
- AJava pool is not configured.
- BThe CPU in the system is slow.
- CThe shared pool size is inadequate.
- DThe database buffer cache is inadequate.
- EThe OPEN_CURSORS parameter is set to a small value.
How the community answered
(22 responses)- A5% (1)
- B14% (3)
- C73% (16)
- E9% (2)
Community Discussion
No community discussion yet for this question.