单选题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 sus

题目
单选题
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

Configure Java Pool to cache the java objects.

B

Configure Streams Pool to enable parallel processing.

C

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

D

Increase Database Buffer Cache size to increase cache hits.

E

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

F

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

更多“单选题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 sus”相关问题