Which action would you consider to overcome the performance degradation?

You find that the database performance degrades while you backup the PROD database using
Recovery Manager (RMAN). The PROD database is running in shared server mode. The
database instance is currently using 60% of total operating system memory. You suspect the
shared pool fragmentation to be the reason. Which action would you consider to overcome the
performance degradation?

You find that the database performance degrades while you backup the PROD database using
Recovery Manager (RMAN). The PROD database is running in shared server mode. The
database instance is currently using 60% of total operating system memory. You suspect the
shared pool fragmentation to be the reason. Which action would you consider to overcome the
performance degradation?

A.
Increase the total System Global Area (SGA) size to increase memory hits.

B.
Increase Database Buffer Cache size to increase cache hits.

C.
Increase Shared Pool size to cache more PL/SQL objects.

D.
Configure Java Pool to cache the java objects.

E.
Configure Streams Pool to enable parallel processing.

F.
Configure Large Pool to be used by RMAN and shared server.



Leave a Reply 0

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