Re: Space Leak Errors with O7.1.3
Date: 1995/12/02
Message-ID: <49ojgm$6nm_at_cloner3.netcom.com>#1/1
In <49o017$me_at_newsbf02.news.aol.com> diamonds2_at_aol.com (Diamonds2)
writes:
>
>We are running Oracle 7.1.3 and nightly we do cold backups doing a
>shutdown immediate and cp's all the associated files. Lately we have
been
>
>getting an ORA-0600 error about a space leak. What is this and how do
we
>solve this problem?
>
>Felicia
>Felicia A. Hemingway
>diamonds2_at_aol.com
>faha_at_eci-esyst.com
Felicia,
A space leak occurs when storage in the SGA is allocated for some temporary purpose, such as a sort, and is not properly freed because the shutdown immediate occurs while the sorting user process is active.
Most space leaks are not serious, ie., no SGA or database corruption has been reported in any related TARs, but they are a pain if you wish to automate your backups.
I suggest you either 'normal' shutdown your instance or call Oracle Support and provide them with the first value in brackets after the ORA-600, ie., [729], [730], [12235], etc., as that will determine the appropriate remedy.
Oracle U.K. Support posted a workaround a month or two ago as a generic workaround for space leaks.
Rich Woods
Oracle Worldwide Customer Support
Received on Sat Dec 02 1995 - 00:00:00 CET