查询共享池shared pool中占用内存最大的前 20 个组件

jiawang

查看共享池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;

登录/注册后可看大图