Oracle OCP知识点讲解（1）

ITAA-OCM · 发表于 2012-1-18 18:21:09

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新能

xiaobudian · 发表于 2012-1-25 15:23:04

支持

xiaobudian · 发表于 2012-1-25 15:24:40

支持

hnjxklj · 发表于 2012-2-15 19:12:43

hnjxklj · 发表于 2012-2-15 19:13:02

mylove201188 · 发表于 2012-2-15 19:14:43

mickeymichael · 发表于 2012-6-13 14:38:26

zengjiawei · 发表于 2013-7-24 08:17:37

zengjiawei · 发表于 2013-7-24 08:29:18

zengjiawei · 发表于 2013-7-24 08:29:56

zengjiawei · 发表于 2013-7-24 08:30:52

zengjiawei · 发表于 2013-7-24 09:01:45

zengjiawei · 发表于 2013-7-24 09:01:58

zengjiawei · 发表于 2013-7-24 09:17:53

zengjiawei · 发表于 2013-7-24 09:19:35

账号		自动登录	找回密码
密码			论坛注册

[注意] Oracle OCP知识点讲解（1）

客服中心

投诉建议