It appears to be working.
Initially ( on startup ) Oracle allocates all memory ( SGA_TARGET - all
other components ) to buffer cache.
If there is a need for bigger shared pool it will take memory from buffer
cache.
Don't know if anything gets invalidated or dirtied when shrink happens.
Regards, Ranko.
On 10/20/05, Vergara, Michael (TEM) <mvergara_at_guidant.com> wrote:
>
> Huh...I remember once long ago it was my shout and I said we wanted
> "Quatros Equis"...
>
> ------------------------------
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Dougie McGibbon
> *Sent:* Thursday, October 20, 2005 12:22 PM
> *To:* oracle-l_at_freelists.org
> *Subject:* RE: Questions about automatic memory allocations in 10g (r1
> andr2)
>
>
> >> And Fosters is NOT Australian for beer.
>
> Nope - ask any Kiwi and they'll tell you that XXXX is Australian for beer.
> Beer was too difficult to spell for most Aussies :-))
>
> Dougie
>
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Oct 20 2005 - 17:41:02 CDT
