Oracle
1Z0-054 · Question #153
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…
The correct answer is C. The per transaction value indicates that write or update transactions have been committed or D. The per second value indicates the total number of data blocks read from disk to the buffer cache. See the full explanation below for the reasoning.
Question
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
Options
- AThe per second value indicates the total number of data blocks read from disk to only the buffer
- BThe per transaction value includes both the db block gets and the consistent gets that occurred
- CThe per transaction value indicates that write or update transactions have been committed or
- DThe per second value indicates the total number of data blocks read from disk to the buffer cache
How the community answered
(42 responses)- A10% (4)
- B19% (8)
- C71% (30)
Community Discussion
No community discussion yet for this question.