Re: PGA not getting released even when nothing is running

From: <sybrandb_at_hccnet.nl>
Date: Fri, 04 Sep 2009 20:30:06 +0200
Message-ID: <o1n2a5lvq4cjv15anotaeqisig2o1vl9q7_at_4ax.com>

On Fri, 4 Sep 2009 11:12:53 -0700 (PDT), Ind-dba <oraclearora_at_googlemail.com> 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