Re: ORA-00600: internal error code

mkoster <member14794_at_dbforums.com> wrote in message news:<3146482.1059028317_at_dbforums.com>...
> hi,
>
> aix 4.3.3 on rs6000;
> oracle 8.1.7.0.0
>
> every day i get even more error-messages in the alert.log
>
> Errors in file
> /dba/app/oracle/product/817/admin/NTEL/udump/ora_102634_ntel.trc:
> ORA-00600: internal error code, arguments: [729], [80], [space leak],
> [], [], [], [], [].
>
> in the user-log i get:
> >>>>>
> *** 2003-07-23 15:41:51.811
> *** SESSION ID:(531.7526) 2003-07-23 15:41:51.809
> ******** ERROR: UGA memory leak detected 80 ********
> ******************************************************
> HEAP DUMP heap name="session heap" desc=0x1101de478
> extent sz=0x10a8 alt=32767 het=32767 rec=0 flg=3 opc=3
> parent=11000d2f0 owner=700000000648ef8 nex=0 xsz=0x10a8
> EXTENT 0
> Chunk 1103a09a0 sz= 4248 free " "
> EXTENT 1
> ......
> <<<<<
>
> what can i do ???

You have basically three possibilities:

1. ignore this - it's just a memory leak, no direct threat to your data or/and functionality. You can eventually set your system to ignore small leaks and to not show this error anymore for them.
2. try to apply latest patch - if i remember correctly memory leaks correction was part of some 8.1.7.x patch.
3. contact Oracle support - but most probably they will suggest you action in article b.

Choice is in yours hands ... In your position I would apply latest patch, because 8.1.7.0.0 is not a most suitable Oracle version to have in production (if this is a productional enviromnent), not only because of these leaks but for several other issues too.

--
Dusan Bolek