Re: Increasing Size of SGA_MAX in Oracle 10G

From: Mladen Gogala <>
Date: Mon, 27 Apr 2009 09:39:55 +0000 (UTC)
Message-ID: <gt3uhb$nn2$>

Na Sun, 26 Apr 2009 19:55:10 -0700, navneel.singh napisao:

> I am running an Oracle 10G clustered database with ASM hosted on a SAM
> system. There are two instances accessing the DB from two different
> machines at any given point of time. Now my question is how do we change
> the parameter value of SGA_MAX_SIZE in such an environment. I tried the
> following and i got the stated error msg
> SQL> create pfile from spfile;
> File created.

After that, apply the vi editor to increase the parameter in the init file. Startup nomount pfile=?/dbs/init_at_.ora and re-create spfile.

Received on Mon Apr 27 2009 - 04:39:55 CDT

Original text of this message