Re: Foolish Question about SGA_MAX_SIZE

On 20 Jun 2006 23:06:41 -0700, leo_at_tech-trans.com wrote:

>Hi!
>
> I tuned the parameter of memory (sga_max_size) in Oracle 9i.
>Unfortunately, it cause Oracle stop. How can I do? One more question,
>any guideline to define the maximum of sga_max_size? Thx!
>
>Ming

No error message, no version, so nothing to work on. Ideally you would need to make sure, increasing the sga_max_size doesn't increase paging and swapping. So, no, you can not set it to the amount of RAM in the machine.

--
Sybrand Bakker, Senior Oracle DBA