Re: PGA not getting released even when nothing is running

From: John Hurley <>
Date: Tue, 15 Sep 2009 16:15:52 -0700 (PDT)
Message-ID: <>

On Sep 4, 3:04 pm, Ind-dba <> wrote:


> Thanks John for your reply!
> >>Are you limiting the amount of PGA space and SGA space on your server
> to reasonable limits?  ( That's kind of what Mr. Bakker was hinting
> that you probably were not doing ).
> The scope of this question is for PGA and we are using dedicated
> server (not shared server mode). Yes we are limiting the PGA to 6G
> using pga_aggregate_target (SGA size 32G Total server memory 64G).
> My question is when does Oracle mark a piece of memory "freeable" in
> PGA?
> As I understand, when the execution of the sql is over, oracle should
> mark the runtime area of PGA memory it used for that operation as
> "freaable", which in this case I don't see.

I don't think "freeable" means that Oracle can free it now.

I think it means that the program connected that caused that memory to be allocated can ( at some point ) free it eventually. Received on Tue Sep 15 2009 - 18:15:52 CDT

Original text of this message