常用的Oracle11g内存视图脚本有哪些
今天就跟大家聊聊有关常用的Oracle 11g内存视图脚本有哪些,可能很多人都不太了解,为了让大家更加了解,小编给大家总结了以下内容,希望大家根据这篇文章可以有所收获。
成都创新互联公司专注于网站建设|成都网站维护公司|优化|托管以及网络推广,积累了大量的网站设计与制作经验,为许多企业提供了网站定制设计服务,案例作品覆盖成都iso认证等行业。能根据企业所处的行业与销售的产品,结合品牌形象的塑造,量身定制品质网站。
今天主要分享几个关于Oracle数据库的内存视图的脚本。
一、V$MEMORY_DYNAMIC_COMPONENTS
V$MEMORY_DYNAMIC_COMPONENTS displays information about the dynamic SGA components. This view summarizes information based on all completed SGA resize operations since instance startup. All sizes are expressed in bytes.
脚本: Provides information about dynamic memory components.
COLUMN component FORMAT A30 SELECT component, ROUND(current_size/1024/1024) AS current_size_mb, ROUND(min_size/1024/1024) AS min_size_mb, ROUND(max_size/1024/1024) AS max_size_mb FROM v$memory_dynamic_components WHERE current_size != 0 ORDER BY component;
二、V$MEMORY_RESIZE_OPS
V$MEMORY_RESIZE_OPS displays information about the last 800 completed memory resize operations (both automatic and manual). This does not include in-progress operations. All sizes are expressed in bytes.
脚本:Provides information about memory resize operations.
SET LINESIZE 200 COLUMN parameter FORMAT A25 SELECT start_time, end_time, component, oper_type, oper_mode, parameter, ROUND(initial_size/1024/1024) AS initial_size_mb, ROUND(target_size/1024/1024) AS target_size_mb, ROUND(final_size/1024/1024) AS final_size_mb, status FROM v$memory_resize_ops ORDER BY start_time;
三、V$MEMORY_TARGET_ADVICE
V$MEMORY_TARGET_ADVICE provides information about how the MEMORY_TARGET parameter should be sized based on current sizing and satisfaction metrics.
脚本3: Provides information to help tune the MEMORY_TARGET parameter.
SELECT * FROM v$memory_target_advice ORDER BY memory_size;
看完上述内容,你们对常用的Oracle 11g内存视图脚本有哪些有进一步的了解吗?如果还想了解更多知识或者相关内容,请关注创新互联行业资讯频道,感谢大家的支持。
网页名称:常用的Oracle11g内存视图脚本有哪些
标题来源:http://myzitong.com/article/ishsgs.html