Re: PGA not getting released even when nothing is running

From: <>
Date: Fri, 04 Sep 2009 20:30:06 +0200
Message-ID: <>

On Fri, 4 Sep 2009 11:12:53 -0700 (PDT), Ind-dba <> wrote:

>Any idea when Oracle shifts used space to freeable space? or when it
>actually releases.

Why should it release? To acquire the memory again after release? That doesn't look very sensible to me.
Look: overallocating the server RAM and making sure it pages constantly is your choice, not Oracle's!

Sybrand Bakker
Senior Oracle DBA
Received on Fri Sep 04 2009 - 13:30:06 CDT

Original text of this message