OraFAQ Forum: Server Administration » Increase SGA dinamically

Home » RDBMS Server » Server Administration » Increase SGA dinamically

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

Increase SGA dinamically [message #390803]

Mon, 09 March 2009 16:16

marcossantos
Messages: 123
Registered: June 2008

Senior Member

Hi,
I get alert about the SGA Size.
I have to increment this value.
But I no want shutdown the Oracle.
How can I do this.
Alter system .... ?

Thanks,
Marcos Santos

[Updated on: Mon, 09 March 2009 16:29]

Report message to a moderator

Re: Increase SGA dinamically [message #390809 is a reply to message #390803]

Mon, 09 March 2009 16:59

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/

>I get alert about the SGA Size.
Alert? What alert? I don't see any alert.

Report message to a moderator

Re: Increase SGA dynamically [message #390810 is a reply to message #390803]

Mon, 09 March 2009 17:00

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

do not cross/multi-post

Report message to a moderator

Re: Increase SGA dynamically [message #390817 is a reply to message #390810]

Mon, 09 March 2009 23:09

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

What's your database version?

If I consider 10g; Then you asking about SGA_MAX_SIZE and SGA_TRAGET ??

Report message to a moderator

Re: Increase SGA dynamically [message #390845 is a reply to message #390817]

Tue, 10 March 2009 00:24

marcossantos
Messages: 123
Registered: June 2008

Senior Member

Hi,
Oracle Database 10g (10.2.0.1) on RHEL5.
I have to increment the value SGA_MAX_SIZE and
to configure automatic management of SGA for the instance.

Thanks,
Marcos Santos

[Updated on: Tue, 10 March 2009 00:27]

Report message to a moderator

Re: Increase SGA dynamically [message #390847 is a reply to message #390845]

Tue, 10 March 2009 00:35

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

SGA_MAX_SIZE

Quote:

Modifiable No

SGA_MAX_SIZE specifies the maximum size of the SGA for the lifetime of the instance.

Regards
Michel

Report message to a moderator

Re: Increase SGA dynamically [message #390848 is a reply to message #390847]

Tue, 10 March 2009 00:48

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

>>I have to increment the value SGA_MAX_SIZE and

Yes you can configure automatic shared management using SGA_MAX_SIZE but you can't changes this parameter dynamically.

SGA_TARGET - This is dynamic parameter

Report message to a moderator