Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Foolish Question about SGA_MAX_SIZE
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!
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