检查 sga
show sga
select * from v$sga;
查看 buffer cache 设置建议
select
size_for_estimate,
estd_physical_read_factor...,seq#,event,p1,p1raw,p2,p2raw,p3,p3raw,state
from v$session_wait
where event like 'library%';
查询 sga...它是从共享池中分配,不是直接从 SGA 中分配的,它是共享池的保留部分,专门用于存储大块段#shared pool 中内存大于_SHARED_POOL_RESERVED_MIN_ALLOC 将放入 shared