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 user’s 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 user’s queries.
Which component of the Oracle Instance would you change to improve performance?

A.
Java pool

B.
Large pool

C.
Shared pool

D.
Streams pool

E.
Library cache

F.
Redo log buffer

G.
Data dictionary cache

H.
Database buffer cache



Leave a Reply 0

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