收到告警 如下
分析:
一、查看当前内存使用情况
free -g 还剩余100度Gb的内存
vmstat 1 100
没有swap 换页 si,so 都是为0
二、数据库层面参数设置
KSPPINM KSPPSTVL KSPPDESC
-------------------------------------- ------------------ ---------------------------------------------
_pga_large_extent_size 1048576 PGA large extent size
_use_ism_for_pga TRUE Use ISM for allocating large extents
_pga_auto_snapshot_threshold 524288000 bytes of PGA memory in one process to triggerdetail snapshot
_pga_auto_snapshot_percentage 20 percent growth of PGA memory for additional snapshots
_pga_detail_combine_auto FALSE combine auto and manual PGA memory detail snapshots
_ldr_pga_lim 0 pga limit, beyond which new partition loads are delayed
_kdli_sio_pga FALSE use PGA allocations for direct IO
_kdli_sio_pga_top FALSE PGA allocations come from toplevel PGA heap
_pgactx_cap_stacks FALSE capture stacks for setting pgactx
pga_aggregate_target 21474836480 Target size for the aggregate PGA memory consumed by the instance
__pga_aggregate_target 21474836480 Current target size for the aggregate PGA memory consumed
_pga_max_size 2147483648 Maximum size of the PGA memory for one process
查看数据库pga
pga_targert=20g
三、分析 日志
共allocal 分配了 4265MB,还剩余1Mb多点
四、查看操作系统内核参数值