Menno Lageman wrote: > Anne Moore wrote: > >> <<I doubt it. If Oracle is taking 1/2 of physical memory by default, it >> will probably do so whether you have 4GB or 40GB.>> >> >> Probably so. But I'm using Zones here, so it may be a different story all >> together. >> >> <<page 94 of http://www.sun.com/blueprints/0505/819-2679.pdf has tunables >> for Oracle 9>> >> >> Thanks. I'm using Oracle 10g 2. I'll see if I can find a article for that. >> (Unfortunately, I don't have a sun solve service plan!) >> >> > > For Oracle 10g you'll probably want to look at the sga_target and > sga_max_size initialization parameters to limit Oracle's use of memory. > > Menno > > Hi Just to clarify a bit, when the Oracle installer is creating a starter database it will take 40% of available memory, ( and in 32 bit up to 4G only is allowable ), But this is just the default ( oracle likes memory and generally will try and take what it can ) So these parameters that go to make up The Oracle System Global Area ( SGA ) can be resized ( and should be for performance/optimisation ) anyway, ie shared_pool_size, large_pool_size block buffers etc, but care should be taken as gettign it wrong can have bad consequence.
Enda _______________________________________________ zones-discuss mailing list email@example.com