重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: 查询共享池shared pool中占用内存最大的前 20 个组件 [打印本页]

作者: jiawang 时间: 2026-4-8 11:52
标题: 查询共享池shared pool中占用内存最大的前 20 个组件

查看共享池TOP占用组件
SELECT name, ROUND(bytes/1024/1024, 2) AS size_mb
FROM v$sgastatWHERE pool = 'shared pool'
ORDER BY bytes DESCFETCH FIRST 20 ROWS ONLY;
或者
SELECT * FROM (
SELECT name,
ROUND(bytes/1024/1024, 2) AS size_mb
FROM v$sgastat
WHERE pool = 'shared pool'
ORDER BY bytes DESC
)
WHERE ROWNUM <= 20;