暂无图片
分享
like052
2019-04-18
kxs-heap-c,kprbalo temp memory

数据库在22点系统scheduler-SQL Tuning调用时偶尔会触发,告警“不能分配内存”,查看trace,当前进程的内存使用率在3-4G之间。

Begin automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"

Thu Mar 08 22:04:21 2018

Errors in file /home/u01/app/oracle/diag/rdbms/qqdb/qqdb2/trace/qqdb2_j002_46800.trc  (incident=72524):

ORA-04030: out of process memory when trying to allocate 432 bytes (kxs-heap-c,kprbalo temp memory)

Incident details in: /home/u01/app/oracle/diag/rdbms/qqdb/qqdb2/incident/incdir_72524/qqdb2_j002_46800_i72524.trc

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

Errors in file /home/u01/app/oracle/diag/rdbms/qqdb/qqdb2/trace/qqdb2_j002_46800.trc  (incident=72525):

ORA-04030: out of process memory when trying to allocate 169040 bytes (pga heap,kgh stack)

ORA-04030: out of process memory when trying to allocate 432 bytes (kxs-heap-c,kprbalo temp memory)

Incident details in: /home/u01/app/oracle/diag/rdbms/qqdb/qqdb2/incident/incdir_72525/qqdb2_j002_46800_i72525.trc

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

Thu Mar 08 22:04:28 2018

Dumping diagnostic data in directory=[cdmp_20180308220428], requested by (instance=2, osid=46800 (J002)), summary=[incident=72525].

Errors in file /home/u01/app/oracle/diag/rdbms/qqdb/qqdb2/incident/incdir_72524/qqdb2_j002_46800_i72524.trc:

ORA-04030: out of process memory when trying to allocate 169040 bytes (pga heap,kgh stack)

ORA-04030: out of process memory when trying to allocate 432 bytes (kxs-heap-c,kprbalo temp memory)

Errors in file /home/u01/app/oracle/diag/rdbms/qqdb/qqdb2/trace/qqdb2_j002_46800.trc  (incident=72526):


收藏
分享
5条回答
默认
最新
Moone

上传1个trace文件

暂无图片 评论
暂无图片 有用 0
like052
暂无图片 评论
暂无图片 有用 0
Moone

1、job使用大量内存,物理内存基本耗尽,导致分配失败

2、相关任务的自动SQL优化,建议可以关闭:

BEGIN

dbms_auto_task_admin.disable(

client_name => 'sql tuning advisor',

operation => NULL,

window_name => NULL);

END;

/

image.png

image.png

image.png

image.png


暂无图片 评论
暂无图片 有用 0
like052

是的。对频繁告警的部分库已经禁用SQL tuning的任务了。

但是通过监控工具,以及告警时查看系统,linux的空闲内存实际上是比348M大很多的。

暂无图片 评论
暂无图片 有用 0
like052
问题已关闭: 问题已经得到解决
暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
附件列表
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏