OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » maxinstances 2

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

maxinstances 2 [message #176865]

Sat, 10 June 2006 14:29

it_me24
Messages: 167
Registered: March 2006
Location: delhi

Senior Member

Hello Everyone
during the creation of the database ,we are using the parameter
maxinstances 2
as i have understood, it means two instances will mount the database.
does that mean there will be two SGA & two set of background processes in the same machine having Oracle server installed.
i fail to understand this.

can anyone help me in this regard.

anticipating UR great help

thanks in Advance.

Report message to a moderator

Re: maxinstances 2 [message #176866 is a reply to message #176865]

Sat, 10 June 2006 14:59

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Are you configuring Oracle RAC? If not then there is no need to specify this parameter while creating a database.

Quote:

The MAXINSTANCES parameter is optional and is primarily used for Real Application Clusters (RAC) environments

Report message to a moderator

Re: maxinstances 2 [message #176869 is a reply to message #176865]

Sat, 10 June 2006 15:44

it_me24
Messages: 167
Registered: March 2006
Location: delhi

Senior Member

thanx for quick response
No i am not using RAC
But if I specify maxinstances 2 does this mean there will be two SGA & two set of background processes in the same machine having Oracle server installed.

thanks.

Report message to a moderator

Re: maxinstances 2 [message #177082 is a reply to message #176865]

Mon, 12 June 2006 23:42

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

I have not tried this on my own but yes if you say maxinstances 2 then it does mean two SGA.

Report message to a moderator

Re: maxinstances 2 [message #177095 is a reply to message #177082]

Tue, 13 June 2006 01:04

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

This parameter is the maximum number of instances that can mount the database when using RAC.

Since you don't use RAC, you will still only have one SGA.

Report message to a moderator

Re: maxinstances 2 [message #177542 is a reply to message #176865]

Thu, 15 June 2006 07:36

it_me24
Messages: 167
Registered: March 2006
Location: delhi

Senior Member

Thank You

Report message to a moderator

Previous Topic:	Cloning of database
Next Topic:	Cursor count at 1,827,775 ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 11:29:40 CDT 2024