: Thursday, June 12, 2003 4:46 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: RAC, fail over and timeout .. Big Question
If your devs are using ADO, do you know if they've tried setting the
.CommandTimeout property of the relevant Connection or Command object? I'm
not sure what
Title: RAC, fail over and timeout .. Big Question
Raj:
I am
afraid, there are not much alternatives you can think of. Even the SELECT fail
over
will takearoundfew seconds since it has to attach the
PGA to the second
instance and run the query from where it is failovered, though you can
, 2003 12:30
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
RAC, fail over and timeout .. Big Question
Raj:
I am
afraid, there are not much alternatives you can think of. Even the SELECT fail
over
will takearoundfew seconds since it has to attach the
PGA to the second
have facts, having an opinion is an art !
-Original Message-From: Loughmiller, Greg
[mailto:[EMAIL PROTECTED]Sent: Thursday, June 12, 2003
2:35 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: RAC, fail over and timeout .. Big Question
It
would be interesting to see
If your devs are using ADO, do you know if they've tried setting the
.CommandTimeout property of the relevant Connection or Command object? I'm
not sure what the analogue is in ADO.Net, tho I'd bet there is one...
Cheers,
-Roy
Roy Pardee
Programmer/Analyst/DBA
SWFPAC Lockheed Martin IT
Title: RE: RAC, fail over and timeout .. Big Question
Roy,
I'll check that ... am not sure if it is ADO, but .NET isn't going to happen here ... not anytime soon.
Raj
Rajendra dot Jamadagni at nospamespn dot