单选题

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?()

AConfigure Java Pool to cache the java objects.

BConfigure Streams Pool to enable parallel processing.

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

DIncrease Database Buffer Cache size to increase cache hits.

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

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

正确答案

来源:www.examk.com

答案解析

相似试题
  • You executed the following commands to find the location of the alert log file: Where is the alert log file stored()

    多选题查看答案

  • When you try to open your database, you receive the following error:  ORA-00205: error in identifying controlfile  Where would you find the details required to resolve this error?()

    单选题查看答案

  • When you try to open your database, you receive the following error:  ORA-00205: error in identifying control file   Where would you find the details required to resolve this error?()

    单选题查看答案

  • You have many users complaining about slow inserts into a large table. While investigating the reason, you find that the number of indexes on the table is high. You want to find out which indexes are not being used.  Which method would you follow to achieve this?()

    单选题查看答案

  • You have many users complaining about slow inserts into a large table. While investigating the reason, you find that the number of indexes on the table is high. You want to find out which indexes are not being used.  Which method would you follow to achieve this?() 

    单选题查看答案

  • You used the following command in Recovery Manager (RMAN) as part of the recovery process: RESTORE CONTROLFILE FROM AUTOBACKUP;  How does RMAN find the control file autobackup?()

    多选题查看答案

  • You used the following command in Recovery Manager (RMAN) as part of the recovery process: RESTORE CONTROLFILE FROM AUTOBACKUP;   How does RMAN find the control file autobackup?()

    多选题查看答案

  • View the Exhibits. You performed operations on the DEPT4 table as shown in the Exhibit. When you perform the FlashbackVersions Query, you find that the first two updates are not listed. What could be the reason?() 

    单选题查看答案

  • You issued the RMAN>SHOW ALL; command. The output of the command is as follows:     After analyzing this output, what conclusion can you draw? ()

    多选题查看答案

  • You are connected to Recovery Manager (RMAN) without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup,you need the database ID (DBID).  In which two sources would you find the DBID? ()

    多选题查看答案