Which two are the possible reasons for the high direct path read time?

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.)

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.)

A.
The I/O subsystem is slow.

B.
The SQL statements are using high CPU.

C.
The SQL statement has a long parsing time.

D.
The SQL statements are performing a large number of physical and logical reads.



Leave a Reply 0

Your email address will not be published. Required fields are marked *