单项选择题
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.
相关考题
-
单项选择题
WhichisthecorrectdescriptionofthesignificanceoftheORACLE_HOMEenvironmentalvariable？（）
A.It specifies the directory containing the Oracle software.
B.It specifies the directory containing the Oracle-Managed Files.
C.It specifies the directory for database files， if not specified explicitly.
D.It specifies the base directory of Optimal Flexible Architecture （OFA） . -
多项选择题
YourdatabaseisconfiguredinNOARCHIVELOGmode.Allthecontrolfileshavebeenlostduetoaharddiskfailurebutthedatafilesarenotlost.Youhavetheclosedwholedatabasebackupavailabletoyou.Whichtwostatementsaretrueinthisscenario？（）
A.The instance aborts.
B.The database cannot be recovered.
C.The database can be recovered by restoring the control files from the backup.
D.The database remains opened and you have to shut it down with the ABORT option.
E.The database can be restored till the point of the last closed whole database backup. -
多项选择题
Whichtwooperationsrequireundodata？（）
A.committing a transaction
B.rolling back a transaction
C.recovering from failed transactions
D.recording a transaction to redo log files
E.rolling forward during instance recovery
