数据库在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):
墨值悬赏

评论




