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

Explanation:



Leave a Reply 2

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


Đồng Nai

Đồng Nai

What is the correct answer if adding “Choose all that apply”?
A + E + G ? I’m concerning!

Dhanushka

Dhanushka

I think A & E not G because large pool not use normal db users