ocp-62

QUESTION NO: 62

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.

Answer: D

---

查看图表，检查下面的查询在三个不同的时间产生的输出，因为数据库实例启动并经历了不同容量的工作负载：
SQL> SELECT substr(component, 0, 10) COMP, current_size CS, user_specified_size US
FROM v$memory_dynamic_components
WHERE current_size!=0;
你从这个推断出什么？

D.数据库实例拥有设置为非零值的内存目标值。

---