Re: shared pool and SGA issues

On Sun, 06 Aug 2006 21:03:26 +0800, Connor McDonald wrote:

> There's been a few bugs with sga_target - maybe revert back to manual
> settings and see if you can reproduce.

Changing the size of SGA isn't something to be taken lightly. I don't see any benefits there yet. The main benefit, in my opinion, would come from software that can reduce memory usage when the instance is inactive. That would make it suitable for use with desktop Linux boxes which would need memory relinquished when using bloatware like the OpenOffice instead of Oracle RDBMS. So far, an instance can grow the SGA allocation, until sga_max_size is reached. That's it. If you have a commercial database server, dedicated to providing database services to a group of users, why not allocate all the memory at once and forget about it, until the machine needs to be seriously reconfigured?
Dynamic SGA allocation would be useful primarily for the small users, playing with Oracle RDBMS at home. It is an omen of the things to come, which may become useful in Oracle 12. It isn't something that would be high on my priority list to implement or even test.

-- 
http://www.mgogala.com