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