Home » RDBMS Server » Server Administration » Increase SGA dinamically
Increase SGA dinamically [message #390803] Mon, 09 March 2009 16:16 Go to next message
marcossantos
Messages: 114
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 Go to previous messageGo to next message
BlackSwan
Messages: 25050
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.
Re: Increase SGA dynamically [message #390810 is a reply to message #390803] Mon, 09 March 2009 17:00 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
do not cross/multi-post
Re: Increase SGA dynamically [message #390817 is a reply to message #390810] Mon, 09 March 2009 23:09 Go to previous messageGo to next message
babuknb
Messages: 1734
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 ??
Re: Increase SGA dynamically [message #390845 is a reply to message #390817] Tue, 10 March 2009 00:24 Go to previous messageGo to next message
marcossantos
Messages: 114
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
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
Re: Increase SGA dynamically [message #390848 is a reply to message #390847] Tue, 10 March 2009 00:48 Go to previous messageGo to next message
babuknb
Messages: 1734
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
Re: Increase SGA dynamically [message #390855 is a reply to message #390848] Tue, 10 March 2009 01:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
SGA_TARGET - This is dynamic parameter

In the limit of SGA_MAX_SIZE which is set by default to SGA_TARGET.

Regards
Michel

[Updated on: Tue, 10 March 2009 01:34]

Report message to a moderator

Re: Increase SGA dinamically [message #390950 is a reply to message #390803] Tue, 10 March 2009 07:28 Go to previous message
marcossantos
Messages: 114
Registered: June 2008
Senior Member
Ok. Thanks.

Marcos Santos
Previous Topic: Issue in running autoconfig in appsTier while cloning
Next Topic: Users unknown
Goto Forum:
  


Current Time: Sat Dec 10 08:51:53 CST 2016

Total time taken to generate the page: 0.04661 seconds