Re: Memory Leak

From: Amit Aggarwal <amaggarwal_at_kendle.com>
Date: 1997/11/12
Message-ID: <3469FB4A.71C8@kendle.com>#1/1

Drexel Pitts wrote:
>
> Oracle 7.1.6 database and we get a "memory leak" when shutting
> down the instance. Any insights???
>
> TIA
We had the same problem in 7.1.3 database. There are two ways to fix it.

You can add an entry in the init.ora file depending on the amount of leakage. The entry looks like this:

event = "10262 trace name context forever, level 4096"

Your leakage should be less than 4K in this case. I am not sure if you can increase this value arbitrarily.

b. Whenever you have to shut down the database, shut it down in the abort mode first, then startup and shut it down normally. You will not see the space leak problem if the database has been running for a very short time.

amit
Oracle DBA/Unix SA Received on Wed Nov 12 1997 - 00:00:00 CST