OCP-1Z0-052-V8.02-117题
来源:互联网 发布:电子商务软件的下载 编辑:程序博客网 时间:2024/06/15 21:15
117. View the Exhibit and examine the initialization parameter settings.
Which three initialization parameters are to be set manually as they are not automatically tuned? (Choose
three.)
A.LOG_BUFFER
B.SORT_AREA_SIZE
C.JAVA_POOL_SIZE
D.STREAMS_POOL_SIZE
E.DB_16K_CACHE_SIZE
F.DB_KEEP_CACHE_SIZE
Answer: AEF
答案解析:
sys@TEST1023> select * from v$sgainfo
2 ;
NAME BYTES RES
-------------------------------- ---------- ---
Fixed SGA Size 2232960 No
Redo Buffers 16326656 No
Buffer Cache Size 1509949440 Yes
Shared Pool Size 436207616 Yes
Large Pool Size 16777216 Yes
Java Pool Size 16777216 Yes
Streams Pool Size 0 Yes
Shared IO Pool Size 0 Yes
Granule Size 16777216 No
Maximum SGA Size 3340451840 No
Startup overhead in Shared Pool 115126096 No
Free SGA Memory Available 1342177280
12 rows selected.
sys@TEST1023> desc v$sgainfo
Name Null? Type
----------------------------------------------------- -------- ------------------------------------
NAME VARCHAR2(32)
BYTES NUMBER
RESIZEABLE VARCHAR2(3)
RESIZEABLE 为YES的在AMM或者ASMM的时候就会自动调整池的大小,为NO的就只能手动调整。
图中sga_target设置有值,故是ASMM管理。
- OCP-1Z0-052-V8.02-117题
- OCP-1Z0-052-V8.02-1题
- OCP-1Z0-052-V8.02-91题
- OCP-1Z0-052-V8.02-92题
- OCP-1Z0-052-V8.02-80题
- OCP-1Z0-052-V8.02-81题
- OCP-1Z0-052-V8.02-82题
- OCP-1Z0-052-V8.02-79题
- OCP-1Z0-052-V8.02-77题
- OCP-1Z0-052-V8.02-23题
- OCP-1Z0-052-V8.02-72题
- OCP-1Z0-052-V8.02-157题
- OCP-1Z0-052-V8.02-156题
- OCP-1Z0-052-V8.02-155题
- OCP-1Z0-052-V8.02-29题
- OCP-1Z0-052-V8.02-110题
- OCP-1Z0-052-V8.02-165题
- OCP-1Z0-052-V8.02-171题
- Linux core dump的详细介绍及使用
- 如何实现Flash中背景变色
- STL:Numberic_limit()
- xml 序列化及反序列化
- JAVA反射机制
- OCP-1Z0-052-V8.02-117题
- Sun如何处理PostgreSQL和Java DB?
- Zookeeper入门指南
- 字符编码问题,UNICODE\UTF-8\UTF-16\UTF-32\UCS\ANSI\GBK\GB2312等乱七八糟的名词
- HTML组合网页(框架组合网页)
- python模块安装:numpy、pylab(转)
- Curl http_code 状态码 意义及信息
- OCP-1Z0-052-V8.02-102题
- java.lang.NoSuchMethodError: org.springframework.web.context.support.XmlWebApplicationContext.getEnv