Which component of the Oracle Instance would you change to improve performance?

Users complain about the slow response time of queries. While investigating the cause you
find that the Oracle Instance is not configured to cache all of the data blocks to satisfy the

users’ queries. Which component of the Oracle Instance would you change to improve
performance?

Users complain about the slow response time of queries. While investigating the cause you
find that the Oracle Instance is not configured to cache all of the data blocks to satisfy the

users’ queries. Which component of the Oracle Instance would you change to improve
performance?

A.
Database buffer cache

B.
Redo log buffer

C.
Library cache

D.
Streams pool

E.
Shared pool

F.
Java pool

G.
Large pool



Leave a Reply 1

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