Re: Help ! ORA-00600 : internal error code

John, You haven't indicated what version of Oracle you are running or what application you where running when you got this error message. These kinds of error messages are best resolved by logging a tar with Oracle support.

I am no expert at 600 error messages, but I believe this error is usually triggered when trying to allocate space in the PGA and the alloc fails. It looks like the PGA was trying to allocate around 32M of space in the PGA and it failed. This may be cause by having SHMMAX set low at the OS level. If this is the case you could try to increase SHMMAX to equal the physical memory on your box. If you are running a PL/SQL program it could be the cursor table is growing and causing the problem. It appears when the cursor table structure runs out of space it reallocates the space and doubles the amount of memory from the previous allocation, then it frees up the older memory chunk. Each time the cursor structor becomes full it doubles the memory again until it makes a request of more than 32M of memory and it fails with the ora-600 error. It seems that on some older versions of Oracle there is maximium of 32M on 32 bit versions of oracle (oracle imposed) when requesting memory for this cursor structure. You may be able to fix the problem with SHMMAX and if that doesn't work you could try to reduce the number of cursors needed by the code.
> Help !
>
> What does this mean?
>
> ORA-00600: internal error cod, arguments : [733], [33719116], [pga heap],
> [], [], [], [], []
>
>
> John
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: John Dunn
> INET: john.dunn_at_sefas.co.uk
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: sheisey_at_att.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).