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).
