一侧ora-4030 的分析

  收到告警 如下

分析：

一、查看当前内存使用情况

  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多点

四、查看操作系统内核参数值