Re: pga_aggregate_target

I think Expert Oracle: Database Arichitecture Chapter 3 (or 4 I don't have it in hand) will help you.

On 12/13/05, The Human Fly <sjaffarhussain_at_gmail.com> wrote:
>
> Hello List,
>
> I was little confused about the settings of pga_aggregate_target
> parameter. I was in a assumption that when we set this parameter to a
> certain value, the usage of pga wont go beond this value. I have set
> pga as 3gb to one of my business critical database. Recently, I have
> found that max pga allocation was 4+ Gb. My boss askmed me, why the
> hell it takes more than what we have defined. I explained him saying
> that oracle might taken it from the OS to finish the necessary
> request. His immediately counter question was, then what is the use of
> setting pga_aggregate_target parameter? When oracle allocates and
> de-allocated the memory (pga) as per requirements.
> Is it expected behaviour that oracle takes sometime more that the
> value defined for pga? If so, what is the benift of setting value for
> pga?
> Thanks for your time.
>
>
> --
> Best Regards,
> Syed Jaffar Hussain
> OCP 8i & 9i DBA,
> Banque Saudi Fransi,
> Saudi Arabia
>
> ----------------------------------------------------------------------------------
> "Winners don't do different things. They do things differently."
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
Yao Yongping
Learning Oracle, UNIX/Linux...
Love Reading, Classical Music, Philosophy, Economics etc.
Blog:  http://spaces.msn.com/members/yaoyp/

--
http://www.freelists.org/webpage/oracle-l