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?
A. There are many physical I/Os happening.
B. There are many full table scans happening.
C. The data blocks are aging out of the buffer cache very fast.
D. There are many cursors trying to access the same data blocks.
E. The DBWn processes are not freeing sufficient buffers to meet the demand.
|
Download Printable PDF. VALID exam to help you PASS. |
 |