Re: Ora-600 Space Leak...Explain, causes

Hi

the event to put in your init.ora is:

event="10262 trace name context forever, level 2000".

This disables checking for space leaks less than 2K, and should be sufficient. Setting the level to 1 disables all space leak checking.

This bug has existed (as posted earlier) for years, and according to my knowledge still exists in 7.3.

Rgds
Steinar Heggelund

fuocor_at_novachem.com wrote:

: On Wed, 02 Apr 1997 07:41:01 -0800, Judie Stroup
: <stroup_at_ops195.lmsc.lockheed.com> wrote:
 

: >Got the following error reported to my alert log...
: >
: >Tue Apr 1 14:54:52 1997
: >Errors in file /fs01/home/oracle/admin/DEV/udump/ora_12361.trc:
: >ORA-00600: internal error code, arguments: [729], [266536], [space
: >leak], [], [], [], [], []
: >
: >Can someone explain what a "space leak" is in this context and what
: >are the possible causes of this error.
: >
: >FYI, I'm running Oracle 7.3.2.3 on HP-UX 10.10.
: >
: >thanks...judie
: >
: >judie.stroup_at_lmco.com

: there is an event that can be set so that this error is ignored when
: the database is being shutdown. I have it somewhere, I will try to
: find and post again.
 

: Regards
: Richard Fuoco

--

----------------------------------------------------------------------------
I'm employed in the Norwegian consulting company Opus One AS. 
I have 7 years experience with Oracle products, mainly the database. 
We are a small company which offers consulting services in design,
implementation and tuning of databases and applications based on Oracle.