Oracle SGA:allocation forceing comonent growth

Mos给出解释:
属于明显的内存抖动故障

排查视图：
通过v$sga_resize_ops可以查询出AMM内存管理下的内存收缩增长分配情况:

V$SGA_RESIZE_OPS官方解释:
displays information about the last 800 completed SGA resize operations. This does not include in-progress operations. All sizes are expressed in bytes.

当前执行的操作记录在v$sga_current_resize_ops

查询：
SQL> select component,oper_type,oper_mode,parameter,initial_size,target_size,final_size,status,start_time,end_time as changed_time
from V$SGA_RESIZE_OPS
where to_char(end_time,‘yyyy-mm-dd hh’)=‘2021-01-25 10’
order by end_time;

AWR-SGA breakdown difference：
此信息非此故障AWR报告

内存抖动,也会出现share pool中latch相关等待,为避免此问题,可以指定share pool大小.