OraFAQ Forum: RAC & Failsafe » PRECONNECT and SELECT behavior ?

Home » Server Options » RAC & Failsafe » PRECONNECT and SELECT behavior ?

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

PRECONNECT and SELECT behavior ? [message #401501]

Tue, 05 May 2009 04:55

tridentadm
Messages: 142
Registered: March 2006

Senior Member

In a a TAF connection with
FAILOVER_MODE = (TYPE=SELECT,METHOD=PRECONNECT)

would the result be that if a instance 1 were to go down the 'selects' run would continue to execute on 2nd instance.

While the sessions established on instance 1 would have same number of sessions established on instance 2.

Report message to a moderator

Re: PRECONNECT and SELECT behavior ? [message #401513 is a reply to message #401501]

Tue, 05 May 2009 05:58

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

would the result be that if a instance 1 were to go down the 'selects' run would continue to execute on 2nd instance.

Yes... theorically

Quote:

While the sessions established on instance 1 would have same number of sessions established on instance 2.

I don't understand this sentence.

Regards
Michel

Report message to a moderator

Re: PRECONNECT and SELECT behavior ? [message #401642 is a reply to message #401513]

Tue, 05 May 2009 21:51

tridentadm
Messages: 142
Registered: March 2006

Senior Member

Quote:

While the sessions established on instance 1 would have same number of sessions established on instance 2.

I don't understand this sentence.

Regards
Michel

I meant to say :
eg.

Instance 1 has : 10 sessions
Instance 2 would have same 10 sessions established cause this is preconnect.

I believe if this is the case then the time would be saved if instance 1 were to fail, because already same number of sessions are established to the 2nd instance.

Report message to a moderator

Re: PRECONNECT and SELECT behavior ? [message #401647 is a reply to message #401642]

Tue, 05 May 2009 23:03

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes there will be the same sessions on other node.

Regards
Michel

Report message to a moderator

Previous Topic:	Plsql Programming Guidelines within a RAC Environment
Next Topic:	ORA 03113 ' end of file ... Communication fails'

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 05 13:08:45 CDT 2025