概述
今天主要分享几个关于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;
觉得有用的朋友多帮忙转发哦!后面会分享更多devops和DBA方面的内容,感兴趣的朋友可以关注下~
本文来自投稿,不代表本人立场,如若转载,请注明出处:http://www.souzhinan.com/kj/215549.html