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

Judie Stroup <stroup_at_ops195.lmsc.lockheed.com> writes:
>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

The space leak has been a bug with Oracle for years now. Basically, UNIX allocates memory for each Oracle instance. You can see this by typing:

ipcs -m

A space leak occurs when this memory is divided up into two (or more) addresses. This typically does not cause problems for users, but may waste UNIX memory. Shut your database down and start it up, and the memory will be cleared.

Oracle typically supplies patches to fix this bug, so give Oracle support a call.

I'm sorry to hear Oracle still has this problem, since we are upgrading to 7.3.2 on HP-UX as well.

-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 50+ technical tips, visit my Web Page:                    <->
<->                                                               <->
<->              http://homepage.interaccess.com/~akaplan         <->
<->                                                               <->
<->             email: akaplan_at_interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->