He is using oracle 8i, where there is no PGA target:).
PGA memory never shrink and release back to OS after it is
allocated.Unless the process exit/killed.
I don't know what is the major difference in oracle 9i/10g, it made,
to lelt oracle release the memory and can be used by other session.
On 5/13/05, Christo Kutrovsky <kutrovsky.oracle_at_gmail.com> wrote:
> The reason why PGA memory never releases is because you are well under
> your pga target.
>=20
> There's is no need to schedule a "release" of this memory, unless your
> target is innapropriate.
>=20
> On 5/5/05, Boivin, Patrice J <BoivinP_at_mar.dfo-mpo.gc.ca> wrote:
> > Thanks.
> >=3D20
> > I can't do this randomly or at set intervals during the night though.
> >=3D20
> > Patrice.
> >=3D20
> > -----Original Message-----
> > From: zhu chao [mailto:zhuchao_at_gmail.com]
> > Sent: May 5, 2005 12:05 PM
> > To: BoivinP_at_mar.dfo-mpo.gc.ca
> > Cc: Oracle-L (oracle-l_at_freelists.org)
> > Subject: Re: Shrinking PGA of snp processes
> >=3D20
> > alter system set job_queue_processes=3D3D0;
> > alter system set job_queue_processes=3D3DX;
> >=3D20
> > On 5/5/05, Boivin, Patrice J <BoivinP_at_mar.dfo-mpo.gc.ca> wrote:
> > > I noticed some of the snp processes take a LOT of memory, probably th=
ei=3D
> r
> > PGA
> > > grows to accommodate the largest nightly jobs.
> > >
> > > Looks like the PGA never shrinks back down, is there a way to force
> > > processes to release PGA memory once they're done using it (in 8i -- =
we=3D
> 're
> > > upgrading soon)?
> > >
> > > Other than setting a lower sort_area_size.
> > >
> > > Patrice.
> > > --
> > > http://www.freelists.org/webpage/oracle-l
> > >
> >=3D20
> > --
> > Regards
> > Zhu Chao
> > www.cnoug.org
> > --
> > http://www.freelists.org/webpage/oracle-l
> >=3D20
>=20
> --=3D20
> Christo Kutrovsky
> Database/System Administrator
> The Pythian Group
> --
> http://www.freelists.org/webpage/oracle-l
>=20
--=20
Regards
Zhu Chao
www.cnoug.org
--
http://www.freelists.org/webpage/oracle-l
Received on Thu May 12 2005 - 21:08:46 CDT