What conclusion can you draw from this?

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?

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.



Leave a Reply 2

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


L. Zhu

L. Zhu

data block high

D is right

ash

ash

from the output,any explanations on why other options is wrong