Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Dynamic SGA and pinned
Jack apparently said,on my timestamp of 3/08/2004 11:54 PM:
> Actually you can set SGA_MAX_SIZE greater than fysical memory and it will
> allocate
> as much as you define in SGA sizes. And it uses for that amount when needed
> on Wintel.
Interesting. Which version? Mine doesn't do that in XP Pro with 9ir2. 10g? Is that swap size only, or nothing at all allocated?
>
> Resizesing SGA_MAX_SIZE need instance restart but other SGA-parameters can
> be changed dynamic.
I think we established that. The issue is that in some OSs, it means nothing as the SGA_MAX_SIZE gets allocated no matter what.
-- Cheers Nuno Souto wizofoz2k_at_yahoo.com.au.nospamReceived on Wed Aug 04 2004 - 05:11:27 CDT