Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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:
Hope this helps!
Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
i2 technologies www.i2.com
"Nuno Souto" <nsouto_at_nsw.bigpo To: Multiple recipients of list ORACLE-L nd.net.au> <ORACLE-L_at_fatcity.com> Sent by: cc: root_at_fatcity.com 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
nsouto_at_nsw.bigpond.net.au
http://www.users.bigpond.net.au/the_Den
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nuno Souto INET: nsouto_at_nsw.bigpond.net.au 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: Riyaj_Shamsudeen_at_i2.com 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).Received on Wed May 02 2001 - 14:41:48 CDT