Re: PGA Memory Leak
From: Larry <104105.3062_at_CompuServe.COM>
Date: 1996/04/20
Message-ID: <4lasqj$6lu$2_at_mhade.production.compuserve.com>#1/1
Date: 1996/04/20
Message-ID: <4lasqj$6lu$2_at_mhade.production.compuserve.com>#1/1
There have been many postings, Feb-Mar especially, discussing
several aspects of memory leaks or memory fragmentation.
Oaracle 7.1, and 7.2 definitely have this problem, 7.3 supposedly
has some fixes.
We have suffered severely due to this. First we began to flush
the shared pool nightly, but then our dba said Oracle thought
this was not a good idea. Finally, in order to have a large
pl/sql block run (at night even!) we had to 'pin' it in memory as
package using the keep command.
Our trace files still show this from time to time but it doesn't seem to cause significant problems. We bounce our instance weekly as part of backup procedures, this flushes memory. Larry Received on Sat Apr 20 1996 - 00:00:00 CEST