Re: PGA not getting released even when nothing is running
Date: Tue, 15 Sep 2009 16:15:52 -0700 (PDT)
Message-ID: <1f17add9-e810-43ac-855f-a2e2dae01e10_at_h30g2000vbr.googlegroups.com>
On Sep 4, 3:04 pm, Ind-dba <oraclear..._at_googlemail.com> wrote:
snip
> 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