Re: Foolish Question about SGA_MAX_SIZE

>>> Unfortunately, it cause Oracle stop

Did you do it during the heave business hrs, which cause oracle to stop?
sga_max_size is not a dynamic parameter, it has to be changed in the init/spfile and restart the database.
Keep little margin of sga_max_size of the total of (buffer_cache,shared_pool,java_pool)

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
Received on Wed Jun 21 2006 - 02:03:31 CDT