Oracle
1Z0-054 · Question #74
You work as a DBA and have the responsibility of managing a large online transaction processing (OLTP) system. You used three queries to check the database performance as shown in the Exhibit.View…
The correct answer is D. There are many cursors trying to access the same data blocks. See the full explanation below for the reasoning.
Question
You work as a DBA and have the responsibility of managing a large online transaction processing (OLTP) system. You used three queries to check the database performance as shown in the Exhibit.View the Exhibit and analyze the output. What conclusion can you draw from this?
Exhibit
Options
- AThere are many physical I/Os happening.
- BThere are many full table scans happening.
- CThe data blocks are aging out of the buffer cache very fast.
- DThere are many cursors trying to access the same data blocks.
- EThe DBWn processes are not freeing sufficient buffers to meet the demand.
How the community answered
(64 responses)- A6% (4)
- B13% (8)
- C2% (1)
- D78% (50)
- E2% (1)
Community Discussion
No community discussion yet for this question.