首页 > 数据库 > 其他综合 >

一侧ora-4030的分析

2017-01-04

一侧ora-4030的分析,free -g 还剩余100度Gb的内存,vmstat 1 100,没有swap 换页 si,so 都是为0。

收到告警 如下:

\

分析:

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

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

\

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

\
相关文章
最新文章
热点推荐