ITAA-OCM 发表于 2012-2-3 14:19:03

Oracle OCP试题解析（22）

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. Answer: E大缓冲池用于为大内存操作提供相对独立的内存空间，通过分配大缓冲池可以提高这些大内存操作的性能：1）使用共享服务器2）使用RMAN在磁带设备上执行备份、转储和恢复操作3）执行并行查询4）使用I/O slaves提高I/O新能

rangeover 发表于 2012-2-11 11:44:08

{:6_267:}

rangeover 发表于 2012-2-11 11:44:19

{:6_267:}

jiazl88 发表于 2012-7-17 16:43:16

{:6_267:}

冰蓝静轩 发表于 2012-8-10 13:57:50

为了学习，努力赚钱。

再辛苦也值得。努力，加油

{:6_267:}
页: [1]
查看完整版本: Oracle OCP试题解析（22）