OraFAQ Forum: Server Administration » I try To Alter SGA but it give ne error

Home » RDBMS Server » Server Administration » I try To Alter SGA but it give ne error (Local Data Base)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

I try To Alter SGA but it give ne error [message #485630]

Thu, 09 December 2010 03:41

alaa_fouad2004
Messages: 64
Registered: January 2009

Member

Hi All
Please I try to alter the SGA it give me error Can any one help me

The Steps which I do

show sga

Total System Global Area  135338868 bytes                                       
Fixed Size                   453492 bytes                                       
Variable Size             109051904 bytes                                       
Database Buffers           25165824 bytes                                       
Redo Buffers                 667648 bytes                                       
SQL> show parameter sga_max_size;

NAME                                 TYPE        VALUE                          
------------------------------------ ----------- ------------------------------ 
sga_max_size                         big integer 135338868      

ALTER SYSTEM SET sga_max_size=200mM SCOPE=spfile;
ALTER SYSTEM SET sga_max_size=200mM SCOPE=spfile
                 *
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified

Report message to a moderator

Re: I try To Alter SGA but it give ne error [message #485660 is a reply to message #485630]

Thu, 09 December 2010 05:47

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Quote:

ALTER SYSTEM SET sga_max_size=200mM SCOPE=spfile

What would be that 200mM?

Report message to a moderator

Re: I try To Alter SGA but it give ne error [message #485663 is a reply to message #485660]

Thu, 09 December 2010 06:04

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

200 miliMEGA.

Report message to a moderator

Re: I try To Alter SGA but it give ne error [message #485735 is a reply to message #485630]

Thu, 09 December 2010 12:26

alaa_fouad2004
Messages: 64
Registered: January 2009

Member

Thanks I update the alter to be
ALTER SYSTEM SET sga_max_size=200M SCOPE=spfile;

Report message to a moderator

Re: I try To Alter SGA but it give ne error [message #486085 is a reply to message #485735]

Mon, 13 December 2010 09:11

najjuizzhere
Messages: 7
Registered: December 2010
Location: BAHRAIN

Junior Member

Hello Friend ,

SQL> select ISSES_MODIFIABLE,ISSYS_MODIFIABLE,name,value from v$parameter
2 where name='sga_max_size';

ISSES ISSYS_MOD NAME VALUE
----- --------- -------------------- ----------
FALSE FALSE sga_max_size 1728053248

Report message to a moderator

Re: I try To Alter SGA but it give ne error [message #486100 is a reply to message #486085]

Mon, 13 December 2010 10:33

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And? Have you something new to say above the previous answers?

Regards
Michel

Report message to a moderator

Previous Topic:	need to load database files on other machine
Next Topic:	how to get tables in oracle 10g database (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 08:41:55 CST 2024