Why does the query on the EMP table not access buffers from the keep pool?

View the Exhibit and analyze the content of V$BUFFER_POOL_STATISTICS.
Why does the query on the EMP table not access buffers from the keep pool?
Exhibit:

View the Exhibit and analyze the content of V$BUFFER_POOL_STATISTICS.

Why does the query on the EMP table not access buffers from the keep pool?

A.
because the query used SCOTT.EMP instead of EMP

B.
because the query with * always uses the default pool

C.
because the query with * always forces physical I/Os that bypass the keep pool

D.
because the blocks of the EMP table are already available in one of the other buffer pools



Leave a Reply 0

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