Re: Increasing Size of SGA_MAX in Oracle 10G

From: Mladen Gogala <gogala.mladen_at_bogus.email.com>
Date: Mon, 27 Apr 2009 09:39:55 +0000 (UTC)
Message-ID: <gt3uhb$nn2$5_at_solani.org>

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.

-- 
http://mgogala.freehostia.com

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