OraFAQ Forum: Server Administration » Difference between Session and Instance???

Home » RDBMS Server » Server Administration » Difference between Session and Instance???

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

Difference between Session and Instance??? [message #54713]

Fri, 29 November 2002 23:39

raman
Messages: 66
Registered: February 2000

Member

Hi

I know Instance means SGA+Background processes!

When do we use multiple instances on a same database? Please provide an example...

thankyou
raj

Report message to a moderator

Re: Difference between Session and Instance??? [message #54743 is a reply to message #54713]

Mon, 02 December 2002 15:10

sharan alva
Messages: 57
Registered: November 1999

Member

Raj,
An instance is a seperate database - ( not considering OPS or RAC ). An oracle_home can have more than one instances, each instance should have it's own SID ( in the same machine ) you cannot have two instances with the same sid running in the same machine.

Sharan

Report message to a moderator

Re: Difference between Session and Instance??? [message #54773 is a reply to message #54743]

Wed, 04 December 2002 05:20

sai sreenivas jeedigunta
Messages: 370
Registered: November 2001

Senior Member

Continuing sharan's answer ,
One instance can have multiple sessions..

sai

Report message to a moderator

Previous Topic:	Don't know what is my connection identifier?
Next Topic:	Fail to startup Database.... urgent!!!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 05:40:23 CDT 2024