今天主要分享几个关于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;
IT之家2月18日消息外媒 Windows Latest 报道,微软正在与谷歌合作进行一项新的改...
首先插件配备好了,写一个HTML测试一下 首先创建一个文件夹,创建一个HTML 文件...
昨天刚学了html的一些内容,就迫不及待的想做个京东上面的搜索条,结果做是做出...
第一课趣味二进制——修改植物大战僵尸数据 任务介绍 学习目标 知识需求 需求工...
JSP spring boot / cloud 使用filter防止XSS 一.前言 XSS(跨站脚本攻击) 跨站脚...
2 月 18 日消息 据外媒 Windowslatest 报道,在预览版本中发现的参考资料表明,...
文章目录 前言 本周最重要的五件事情 本周搞砸的四件事情 本周的四个启发 前言 ...
在项目开始之前我们可以先去了解一下IConfiguration接口,.Net Core Web应用程序...
一.前言 .NET Core 是一个通用开发平台,由 Microsoft 和 GitHub 上的 .NET 社区...
1.ajax跨域传递值是所需要的回传的类型为jsonp $.ajax({url: "http://.......",t...