Oracle
1Z0-054 · Question #44
You are managing an online transaction processing (OLTP) system. Many users complain about the slow response time. You investigated and found that in the Top 5 events, direct path read accounts for…
The correct answer is A. The I/O subsystem is slow. D. The SQL statements are performing a large number of physical and logical reads. See the full explanation below for the reasoning.
Question
You are managing an online transaction processing (OLTP) system. Many users complain about the slow response time. You investigated and found that in the Top 5 events, direct path read accounts for 73.2% of the total wait time.Which two are the possible reasons for the high direct path read time? (Choose two.)
Options
- AThe I/O subsystem is slow.
- BThe SQL statements are using high CPU.
- CThe SQL statement has a long parsing time.
- DThe SQL statements are performing a large number of physical and logical reads.
How the community answered
(28 responses)- A71% (20)
- B18% (5)
- C11% (3)
Community Discussion
No community discussion yet for this question.