ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-00600 [723], [67108952], [pga heap]

ORA-00600 [723], [67108952], [pga heap]

Linux操作系统 作者:湖湘文化 时间:2013-11-16 18:25:21 0 删除 编辑
2012 0417 

查看告警日志发现的问题:
关于pga的报错信息:
ora 600 723 67108952 pga heap

说明:当前数据库SGA设置为14400MPGA4G


event 10261 Limit the size of the PGA heap

metlink 相关文档:
ORA-00600 [723], [67108952], [pga heap] When Event 10261 Set To Limit The PGA Leak [ID 1162423.1]

-----------------------------------------------------------------------

修改时间 06-MAY-2011 类型 PROBLEM 状态 PUBLISHED

In this Document
Symptoms
ORA-00600: internal error code, arguments: [723], [67108952], [pga heap], [], [], [], [], []
Changes
Cause
Solution
References

--------------------------------------------------------------------------------


Symptoms

ORA-00600: internal error code, arguments: [723], [67108952], [pga heap], [], [], [], [], []

In trace file....

ERROR: PGA size limit exceeded: 3224886936 > 3221225472
--------------------------------------------------------------------------------------
HEAP DUMP heap name="pga heap" desc=0x685f220
extent sz=0x20c0 alt=184 het=32767 rec=0 flg=2 opc=1
parent=(nil) owner=(nil) nex=(nil) xsz=0x400fff0
EXTENT 0 addr=0x2b50136010
Chunk 2b50136020 sz= 65432 free " "
Chunk 2b50145fb8 sz= 67108936 freeable "qesmmCheckPgaL " ds=0x2a97c2b1e8
EXTENT 1 addr=0x2b4c126010


Call stack functions
---------------------------------
ksmapg <- kghgex <- kghfnd <- kghalo<- kghgex <- kghfnd <- kghprmalo <- kghalp <- qesmmCheckPgaLimit


Changes
#In init.ora/spfile.ora, the below event have been set to limit the PGA memory leak.
event = 10261 trace name context forever,level 3145728


Event 10261 "Limit the size of the PGA heap


Event 10261
Text: Limit the size of the PGA heap

Description:
This event is useful for PGA memory leaks (and UGA if the UGA is in the PGA). The event causes Oracle to raise an ORA-600 if the PGA tries to grow above the specified size. A PGA heapdump is produced but additional information can be dumped for other heaps by setting an event on ORA-600 within the target process.

Level:
The limit is one kilobyte times the level of the event. If the pga grows bigger than this we signal an internal error.


Cause
The ORA-600 [723] error was reported because the Event 10261 was set for 3145728k (Approximately 3.2 GB)

In pfile/spfile, the below event
event = 10261 trace name context forever,level 3145728


Solution
ORA-600 [723] error has been reported because EVENT 10261 has been set to ~3.2Gb. The process getting the error exceeded ~3.2Gb in memory usage; so oracle reported the error and terminated the process.

event = 10261 trace name context forever,level 3145728
This is expected because, when event set with the above values, when a process reaches ~3.2GB of PGA memory, it will abort the process, report ORA-600 [723] and generate a trace file accordingly.


Please unset this event

OR

User can ignore this error.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/21256317/viewspace-776758/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-05-31

  • 博文量
    108
  • 访问量
    1521710