Re: Help ! ORA-00600 : internal error code
this is an error code that must be reported to Oracle support along with full description of error, procedure performed that caused this error and also details about your database environment settings. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 26, 2001 12:01 PM 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Saurabh Sharma INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Help ! ORA-00600 : internal error code
Earlier it used to mean Goto Oracle Support But now you have a choice. http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html And it works . most of the cases... HTH, Rajesh -Original Message- Sent: Thursday, July 26, 2001 10:31 AM To: Multiple recipients of list ORACLE-L 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Rajesh Dayal INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Help ! ORA-00600 : internal error code
I enclose a metalink document that I have because of that error. Obsviously it is related with the PGA. However I add sth in contradiction with the note, I've seen a similar problem on 8.1.7. That I've resolved setting the event 10262. Doc ID: Note:131490.1 big for this port (o/s) Type: REFERENCE Status: REVIEWED Content Type: TEXT/PLAIN Creation Date: 04-JAN-2001 Last Revision Date: 25-MAY-2001 Note: For additional ORA-600 related information please read [NOTE:146580.1] PURPOSE: This article discusses the internal error ORA-600 [733], what it means and possible actions. The information here is only applicable to the versions listed and is provided only for guidance. ERROR: ORA-600 [733][a][b][c][d][e] VERSIONS: versions 7.3.X to 8.1.X DESCRIPTION: When allocating an extent in the PGA, if the minimum size requested is greater than what is allowed for this port, ORA-00600 [733] is logged. Program Global Area (PGA) heap/memory allocation error. No data corruption occurs. ARGUMENTS: [733][min_size][comment] [min_size] The minimum extent size requested, in bytes. [comment] A comment supplied by the caller. FUNCTIONALITY: MEMORY IMPLEMENATION IMPACT: PROCESS FAILURE NON CORRUPTIVE - No corruption to underlying data. SUGGESTIONS: Known issues: Bug 553250 when trying to bind 32K in a PL/SQL table, fixed in 8.1.7 release. If receiving this during a query with complex JOIN, for example, consider lowering sort_area_size or hash_area_size if hash_join_enabled = true and rerun the query again so the PGA memory requirements aren't as large. REgards. --- John Dunn [EMAIL PROTECTED] wrote: 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Help ! ORA-00600 : internal error code
Thank you Rajesh, Some of Oracle bugs are internal, you may not see all bugs. So, I've added email feature to iOraBugFinder. Now, you can send the results and uploaded file to Oracle support if iOraBugFinder doesn't return your bugs. Since trace files are analyzed, response time from Oracle support is reduced. Recommendations: - Don't upload alert file when bug depth = 0 - Upload trace file instead of alert - Use higher level bug to get close to your bug. If it doesn't return bug, select lower levels. regards.. 26/7/01 11:20:50, Rajesh Dayal [EMAIL PROTECTED] wrote: Earlier it used to mean Goto Oracle Support But now you have a choice. http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html And it works . most of the cases... HTH, Rajesh -Original Message- Sent: Thursday, July 26, 2001 10:31 AM To: Multiple recipients of list ORACLE-L 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Rajesh Dayal INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Help ! ORA-00600 : internal error code
That I've resolved setting the event 10262. Sorry ..I didn't understand that bit. Can you clarify please John -Original Message- From: Christian Trassens [SMTP:[EMAIL PROTECTED]] Sent: 26 July 2001 10:37 To: Multiple recipients of list ORACLE-L Subject: Re: Help ! ORA-00600 : internal error code I enclose a metalink document that I have because of that error. Obsviously it is related with the PGA. However I add sth in contradiction with the note, I've seen a similar problem on 8.1.7. That I've resolved setting the event 10262. Doc ID: Note:131490.1 big for this port (o/s) Type: REFERENCE Status: REVIEWED Content Type: TEXT/PLAIN Creation Date: 04-JAN-2001 Last Revision Date: 25-MAY-2001 Note: For additional ORA-600 related information please read [NOTE:146580.1] PURPOSE: This article discusses the internal error ORA-600 [733], what it means and possible actions. The information here is only applicable to the versions listed and is provided only for guidance. ERROR: ORA-600 [733][a][b][c][d][e] VERSIONS: versions 7.3.X to 8.1.X DESCRIPTION: When allocating an extent in the PGA, if the minimum size requested is greater than what is allowed for this port, ORA-00600 [733] is logged. Program Global Area (PGA) heap/memory allocation error. No data corruption occurs. ARGUMENTS: [733][min_size][comment] [min_size] The minimum extent size requested, in bytes. [comment] A comment supplied by the caller. FUNCTIONALITY: MEMORY IMPLEMENATION IMPACT: PROCESS FAILURE NON CORRUPTIVE - No corruption to underlying data. SUGGESTIONS: Known issues: Bug 553250 when trying to bind 32K in a PL/SQL table, fixed in 8.1.7 release. If receiving this during a query with complex JOIN, for example, consider lowering sort_area_size or hash_area_size if hash_join_enabled = true and rerun the query again so the PGA memory requirements aren't as large. REgards. --- John Dunn [EMAIL PROTECTED] wrote: 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: John Dunn INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Help ! ORA-00600 : internal error code
call support. joe John Dunn wrote: 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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) -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Help ! ORA-00600 : internal error code
I've seen another 0600 related with yours. The 0600 was 0600 [723]. And the solution for that was setting the event 10262 in the following way: event=10262 trace name context forever, level 2000 This appeared on a 8.1.7.1 database in Solaris. That was what I meant. Regards. PS: Have you solved it ?. --- John Dunn [EMAIL PROTECTED] wrote: That I've resolved setting the event 10262. Sorry ..I didn't understand that bit. Can you clarify please John -Original Message- From: Christian Trassens [SMTP:[EMAIL PROTECTED]] Sent: 26 July 2001 10:37 To: Multiple recipients of list ORACLE-L Subject:Re: Help ! ORA-00600 : internal error code I enclose a metalink document that I have because of that error. Obsviously it is related with the PGA. However I add sth in contradiction with the note, I've seen a similar problem on 8.1.7. That I've resolved setting the event 10262. Doc ID: Note:131490.1 big for this port (o/s) Type: REFERENCE Status: REVIEWED Content Type: TEXT/PLAIN Creation Date: 04-JAN-2001 Last Revision Date: 25-MAY-2001 Note: For additional ORA-600 related information please read [NOTE:146580.1] PURPOSE: This article discusses the internal error ORA-600 [733], what it means and possible actions. The information here is only applicable to the versions listed and is provided only for guidance. ERROR: ORA-600 [733][a][b][c][d][e] VERSIONS: versions 7.3.X to 8.1.X DESCRIPTION: When allocating an extent in the PGA, if the minimum size requested is greater than what is allowed for this port, ORA-00600 [733] is logged. Program Global Area (PGA) heap/memory allocation error. No data corruption occurs. ARGUMENTS: [733][min_size][comment] [min_size] The minimum extent size requested, in bytes. [comment] A comment supplied by the caller. FUNCTIONALITY: MEMORY IMPLEMENATION IMPACT: PROCESS FAILURE NON CORRUPTIVE - No corruption to underlying data. SUGGESTIONS: Known issues: Bug 553250 when trying to bind 32K in a PL/SQL table, fixed in 8.1.7 release. If receiving this during a query with complex JOIN, for example, consider lowering sort_area_size or hash_area_size if hash_join_enabled = true and rerun the query again so the PGA memory requirements aren't as large. REgards. --- John Dunn [EMAIL PROTECTED] wrote: 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: John Dunn INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT
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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Help ! ORA-00600 : internal error 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).