admin管理员组

文章数量:1608839

Oracle数据库案例整理-Oracle系统运行时故障-内存过少导致分配共享内存失败

1.1       现象描述

Oracle分配共享内存失败,ALTER日志显示如下错误信息。

Errors in file /oracle/db/diag/rdbms/ora01/ora01/trace/ora01_reco_233670.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-04031: unable to allocate 4064 bytes of shared memory ("shared pool","select local_tran_id, global...","sga heap(1,0)","kglsim heap")

Sat Jan 15 09:53:11 2011

DDE: Problem Key 'ORA 4031' was completely flood controlled (0x6)

Further messages for this problem key will be suppressed for up to 10 minutes

Sat Jan 15 10:03:11 2011

DDE: Problem Key 'ORA 4031' was completely flood controlled (0x6)

Further messages for this problem key will be suppressed for up to 10 minutes

Sat Jan 15 10:13:11 2011

DDE: Problem Key 'ORA 4031' was completely flood controlled (0x4)

本文标签: 内存过少故障分配案例