Re: PGA not getting released even when nothing is running
Date: Tue, 15 Sep 2009 16:15:52 -0700 (PDT)
On Sep 4, 3:04 pm, Ind-dba <oraclear..._at_googlemail.com> 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
> 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