Which two statements are correct about the values of the Physical reads events?

View the Exhibit and examine the Load Profile from the AWR report of a test database.The application must process an average of 10,000 very small transactions per day. The bulk of the processing activity is for DML operations with minimal to nil query processing.
Which two statements are correct about the values of the Physical reads events? (Choose two.)
Exhibit:

View the Exhibit and examine the Load Profile from the AWR report of a test database.The application must process an average of 10,000 very small transactions per day. The bulk of the processing activity is for DML operations with minimal to nil query processing.

Which two statements are correct about the values of the Physical reads events? (Choose two.)

A.
The per second value indicates the total number of data blocks read from disk to only the buffer cache.

B.
The per transaction value includes both the db block gets and the consistent gets that occurred during the last sample period.

C.
The per transaction value indicates that write or update transactions have been committed or rolled back during the last sample period.

D.
The per second value indicates the total number of data blocks read from disk to the buffer cache including reads bypassing the buffer cache, and reads into process private buffers.



Leave a Reply 1

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