ORA-00600: internal error code, arguments: [729], [1600], [space leak], [], [], [], [], []

Sat Aug 25 09:56:52 2012
Errors in file /oracle/admin/racdb/udump/racdb1_ora_1630378.trc:
ORA-00600: internal error code, arguments: [729], [1600], [space leak], [], [], [], [], []

http://blog.itpub.net/post/7167/494314

ORA-00600: internal error code, arguments: [729], [2101416], [space leak]

作者 zhang41082 15:39 |    静态链接网址 |   最新回复 (0) |   引用 (1) |       ORACLE BUG

一个数据库最近每天会报一个600的错，查了下ML，说这个错是因为申请UGA的时候内存不够造成的，需要申请的内存的大小就是第二个参数那里的值，那么 这里就应该是因为要申请2101416，将近2M内存的时候报的错。而这个报错不会引起数据的问题，只是在进程结束的时候产生的进程失败，所以其实是没什 么影响的。如果申请的是4000字节以下的，可以通过设置10262参数来避免这个问题，显然这个CASE不能通过这个来实现。而且跟这个错误相关的BUG一大堆，查下来发现是跟我们每天晚上有一个EXP的逻辑备份有关。既然没啥关系，过滤掉就是了。

详细信息请查看ML：31056.1

ERROR:             
  ORA-600 [729] [a]

VERSIONS:          
  versions 7.0 to 10.1

DESCRIPTION:       

  A space leak has been detected in the User Global Area (UGA).

  There is NO data corruption as a result of this error.

  It is an internal memory housekeeping problem.

ARGUMENTS:
  Arg [a] This is the number of bytes leaked

FUNCTIONALITY:     
  MEMORY COMPONENT

IMPACT:            
  PROCESS FAILURE - But only during logoff so impact is minimal.
  NON CORRUPTIVE - No underlying data corruption.


SUGGESTIONS:       

  Event 10262 can be set to safely ignore small memory leaks.

  Set the following in init.ora for example to disable space
  leaks less than 4000 bytes:

        event = "10262 trace name context forever, level 4000"

  and stop and restart the database.

  Repeated errors or large memory leaks can be diagnosed further by
  sending the alert.log and trace files to Oracle support.