55.View the Exhibit to examine the output produced by the following query at three different times s

最新推荐文章于 2025-08-27 12:36:22 发布

原创最新推荐文章于 2025-08-27 12:36:22 发布 · 1k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#1z0-052

1z0-052 专栏收录该内容

187 篇文章

订阅专栏

本文通过三次不同时间点的查询结果对比，分析了数据库实例启动后的内存动态管理情况，并推断出该实例设置了MEMORY_TARGET参数为非零值。文章还解释了V$MEMORY_DYNAMIC_COMPONENTS视图如何帮助理解各种内存组件的变化。

55.View the Exhibit to examine the output produced by the following query at three different times since
the database instance started and has experienced 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.The database instance is running with manual PGA management.
B.The database instance is running with manual shared memory management.
C.The database instance has the MEMORY_TARGET value set to a nonzero value.
D.All sessions are connected to the database instance in dedicated mode, and no RMAN or parallel query operations have been performed.
MM is set to 100 MB.
答案：C
解析：从图中可以看出sga_target和pga_target三次都不一样，说明启用了amm
因此选择C，具体内容可以参考53题
V$MEMORY_DYNAMIC_COMPONENTS：动态查询各个内存组件的大小