OCP 1Z0 053 162
162.View the Exhibit to examine the output produced by the following query at three different times since
the database instance started and has undergone workloads of different capacities:
SQL> SELECT substr(component, 0, 10) COMP, current_size CS,
user_specified_size US
FROM v$memory_dynamic_components
WHERE current_size!=0;
What do you infer from this?
A. All sessions are connected to the database instance in dedicated mode, and no RMAN or parallel
query operations have been performed.
B. The database instance is running with manual shared memory management.
C. The database instance is running with manual PGA management.
D. The database instance has the MEMORY_TARGET value set to a nonzero value.
the database instance started and has undergone workloads of different capacities:
SQL> SELECT substr(component, 0, 10) COMP, current_size CS,
user_specified_size US
FROM v$memory_dynamic_components
WHERE current_size!=0;
What do you infer from this?
A. All sessions are connected to the database instance in dedicated mode, and no RMAN or parallel
query operations have been performed.
B. The database instance is running with manual shared memory management.
C. The database instance is running with manual PGA management.
D. The database instance has the MEMORY_TARGET value set to a nonzero value.
Answer: D
sga自动调整，说明MEMORY_TARGET 设置非0，启用了asm
声明：该文观点仅代表作者本人，牛骨文系教育信息发布平台，牛骨文仅提供信息存储空间服务。
- 上一篇： 5 icetool 学习笔记
- 下一篇： DFSORT之shift right
