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?

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 1

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


L. Zhu

L. Zhu

if the table blocks are already in other buffer pools, it won’t be re-allocated

so D is right