Re: PGA not getting released even when nothing is running

From: Ind-dba <>
Date: Fri, 4 Sep 2009 12:04:59 -0700 (PDT)
Message-ID: <>

> The first four chapters including chapter 4 Memory Structures should
> give you the background you need.

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.

>> It is always helpful when you post a question here to give some
technical background like what version of oracle, what operating system, what patchset level, how much memory available on the server, etc.

This is database on Linux. Received on Fri Sep 04 2009 - 14:04:59 CDT

Original text of this message