Re: Foolish Question about SGA_MAX

From: Laurenz Albe <invite_at_spam.to.invalid>
Date: 21 Jun 2006 08:12:51 GMT
Message-ID: <1150877569.685078@proxy.dienste.wien.at>

Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote:
> On 20 Jun 2006 23:06:41 -0700, leo_at_tech-trans.com wrote:

>>  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!

>
> 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.

I assume that SGA_MAX_SIZE was changed to a value larger than the amount of memory that can be allocated. That would prevent the database from starting.

Change the value back in the PFILE or SPFILE, then be more careful next time.

Yours,
Laurenz Albe Received on Wed Jun 21 2006 - 03:12:51 CDT

Re: Foolish Question about SGA_MAX_SIZE