OraFAQ Forum: Server Administration » SGA_MAX_SIZE auto created -- create database command manully

Home » RDBMS Server » Server Administration » SGA_MAX_SIZE auto created -- create database command manully

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

SGA_MAX_SIZE auto created -- create database command manully [message #250508]

Tue, 10 July 2007 05:44

somavamshi
Messages: 17
Registered: July 2007
Location: bangalore

Junior Member

Hi ...

While creating the database through create database command on command line setting shared_pool_size,db_cache_size,etc...

Will the SGA_MAX_SIZE will auto analyzed and adjusted calculating the respective sizes mentioned above variables in the init<sid>.ora file.

I haven't used the SGA_MAX_SIZE in the init<sid>.ora file , only shared_pool_size and db_cache_size,java_pool_size,pga_aggregate_target etc.,

??????? Smile

Report message to a moderator

Re: SGA_MAX_SIZE auto created -- create database command manully [message #250600 is a reply to message #250508]

Tue, 10 July 2007 10:49

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Did you get message

Datbase Created.

Report message to a moderator

Re: SGA_MAX_SIZE auto created -- create database command manully [message #250961 is a reply to message #250600]

Thu, 12 July 2007 01:15

somavamshi
Messages: 17
Registered: July 2007
Location: bangalore

Junior Member

Hi

I yet to be created. This doubt before creating the database.
My question is that Is that we need to initialize the SGA_MAX_SIZE param in the init<sid>.ora file.
If not so what happens.

Report message to a moderator

Re: SGA_MAX_SIZE auto created -- create database command manully [message #250987 is a reply to message #250961]

Thu, 12 July 2007 02:21

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

Senior Member
Account Moderator

Quote:

If not so what happens.

Oracle takes a default value.

Regards
Michel

Report message to a moderator

Previous Topic:	ORA-error stack
Next Topic:	Australia Time Zone settings

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:54:35 CDT 2024