Anybody getting ORA-00600 [729] [space leak] on a regular base?`
In the alert log? HP9K, HP-UX, Oracle 8.0.6.0. I'm getting about 6 a day. No apparent harm to the DB. Metalink as usual says: "can't reproduce problem" to most of these bugs. Couldn't find a concrete fix to this anywhere. Nope, I'm not using direct export. TIA for any feedback. Cheers Nuno Souto [EMAIL PROTECTED] http://www.users.bigpond.net.au/the_Den -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nuno Souto 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: Anybody getting ORA-00600 [729] [space leak] on a regular base?`
Hi We had ORA-00600 [729] problem on a regular basis too. I am not sure about your database errors, but in out database these errors are due to audit_trail being turned on. In the PGA Ptvt. Audit Info memory chunks are not being considered and they are being falsely identified as space leak. If you look at the trace file and add up all the chunk sizes for the Prvt. Audit Info chunks, you could see that they match to the bytes reported in the ORA-600 parameter. grep "Pvt. audit info" otmxp02_ora_10424.trc |awk '{sum+=$4}END {print sum}' 25256 >From the trace file: *** 2001.04.17.09.29.42.000 *** SESSION ID:(30.22436) 2001.04.17.09.29.42.000 ERROR: UGA memory leak detected 25256 ** Hope this helps! Thanks Riyaj "Re-yas" Shamsudeen Certified Oracle DBA i2 technologies www.i2.com "Nuno Souto" <[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L nd.net.au> <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: Anybody getting ORA-00600 [729] [space leak] on a regular base?` 05/02/01 09:19 AM Please respond to ORACLE-L In the alert log? HP9K, HP-UX, Oracle 8.0.6.0. I'm getting about 6 a day. No apparent harm to the DB. Metalink as usual says: "can't reproduce problem" to most of these bugs. Couldn't find a concrete fix to this anywhere. Nope, I'm not using direct export. TIA for any feedback. Cheers Nuno Souto [EMAIL PROTECTED] http://www.users.bigpond.net.au/the_Den -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nuno Souto 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).
Re: Anybody getting ORA-00600 [729] [space leak] on a regular base?`
It is relating to incomplete/terminated export of database or any large table. You may check this happening to your systemOracle patch 7.3.4.5 claims that it is fixed but it is still the problem... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Wed, 02 May 2001 06:19:31 -0800 In the alert log? HP9K, HP-UX, Oracle 8.0.6.0. I'm getting about 6 a day. No apparent harm to the DB. Metalink as usual says: "can't reproduce problem" to most of these bugs. Couldn't find a concrete fix to this anywhere. Nope, I'm not using direct export. TIA for any feedback. Cheers Nuno Souto [EMAIL PROTECTED] http://www.users.bigpond.net.au/the_Den -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nuno Souto 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq 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: Anybody getting ORA-00600 [729] [space leak] on a regular base?`
Oracle rep told us to report ORA-600 to Oracle which would inturn help them in developing bug fixes. HTH. JyotiGet Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jyoti Randive 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: Anybody getting ORA-00600 [729] [space leak] on a regular base?`
That error is in their knowledge and they can check in patchset note for 7.3.4.5 for fixes and they claim it is fixed but problem still exist while terminating export while database goes down. We have this problem with HP-10.20 and version 7.3.4.5 Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> base?` Date: Wed, 02 May 2001 09:30:28 -0800 _ Get your FREE download of MSN Explorer at http://explorer.msn.com Oracle rep told us to report ORA-600 to Oracle which would inturn help them in developing bug fixes. HTH. JyotiGet Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jyoti Randive 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: Anybody getting ORA-00600 [729] [space leak] on a regular base?`
Space leaks = Oracle malloced memory and did not free it when done. There is actually an init.ora event that can be set to ignore memory leaks so you don't have to see them in your alert log. 10262, 0, "Don't check for memory leaks" // *Cause:Setting this event to level one causes memory leak checking to //be disabled. Setting this event to any other non-zero number //allows that number to be used as a threshold value when checking //for memory leaks in the PGA, SGA, and UGA heaps. Jared On Wednesday 02 May 2001 07:19, Nuno Souto wrote: > In the alert log? > HP9K, HP-UX, Oracle 8.0.6.0. > I'm getting about 6 a day. > No apparent harm to the DB. > Metalink as usual says: "can't reproduce > problem" to most of these bugs. > Couldn't find a concrete fix to this anywhere. > Nope, I'm not using direct export. > > TIA for any feedback. > Cheers > Nuno Souto > [EMAIL PROTECTED] > http://www.users.bigpond.net.au/the_Den -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: Anybody getting ORA-00600 [729] [space leak] on a regular base?`
Yes, but when one does a search on Metalink for this problem and finds out they have it reported many times with "cannot reproduce, closed", it's not very encouraging, is it? ;-) Cheers Nuno Souto [EMAIL PROTECTED] http://www.users.bigpond.net.au/the_Den - Original Message - > Oracle rep told us to report ORA-600 to Oracle which would inturn help them in developing bug fixes. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nuno Souto 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: Anybody getting ORA-00600 [729] [space leak] on a regular base?`
Nope. No audit here... Thanks anyway. Cheers Nuno Souto [EMAIL PROTECTED] http://www.users.bigpond.net.au/the_Den - Original Message - > about your database errors, but in out database these errors are due to > audit_trail being turned on. In the PGA Ptvt. Audit Info memory chunks are -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nuno Souto 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: Anybody getting ORA-00600 [729] [space leak] on a regular base?`
I'm a bit suss on ignoring them. The mem in use from glance doesn't increase. Might be a side effect of something else? Dunno, it's got me stumped. Been happening since we moved from 8.0.5.2 to 8.0.6.0. Maybe I should just slap on the 8.0.6.2 patch? Going back to 8.0.5 is no option, not supported. (not that I feel a lot of support right now...) Thanx for the info, BTW. Cheers Nuno Souto [EMAIL PROTECTED] http://www.users.bigpond.net.au/the_Den - Original Message - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nuno Souto 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: Anybody getting ORA-00600 [729] [space leak] on a regular base?`
We do daily exports, but our largest table is not that large. And they all complete, no errors. Heaps of tables, though. Also, this is 8.0.6. I'd expect the darn thing to be fixed by now! Thanks for the info. Cheers Nuno Souto [EMAIL PROTECTED] http://www.users.bigpond.net.au/the_Den - Original Message - > It is relating to incomplete/terminated export of database or any large > table. You may check this happening to your systemOracle patch 7.3.4.5 > claims that it is fixed but it is still the problem... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nuno Souto 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: Anybody getting ORA-00600 [729] [space leak] on a regular base?`
On Wed, 02 May 2001, Nuno Souto wrote: > In the alert log? We used to get these on a regular basis - HP9000, HP-UX 11, 8.0.5 Oracle basically said it was a bug, live with it (didn't cause any data corruption or database instability) or upgrade. Cheers, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron 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).