Oracle Server - how to specify timeout in connectionstring????????

Author

how to specify timeout in connectionstring????????

2005-07-26, 1:23 pm

Hi Folks,

In sql, we can specify timeout attribute in connection string. In the
similar way , does oracle allow to specify timeour parameter in
connection string?.........If yes then plse let me know the connection
string with timeout attribute.

Thanks in advanced,
DB

Sybrand Bakker

2005-07-26, 1:23 pm

On 26 Jul 2005 10:16:31 -0700, "db" < deepakbadki@rediffma
il.com>
wrote:

>Hi Folks,
>
>In sql, we can specify timeout attribute in connection string. In the
>similar way , does oracle allow to specify timeour parameter in
>connection string?.........If yes then plse let me know the connection
>string with timeout attribute.
>
>Thanks in advanced,
>DB

Oracle != sqlserver, so there is no 'timeout attribute'

--
Sybrand Bakker, Senior Oracle DBA

Andreas Sheriff

2005-07-26, 1:23 pm

"Sybrand Bakker" <postbus@sybrandb.demon.nl> wrote in message
news:kvvce1t5k8h8liq
c6mkmkc4qajb0i3idhg@
4ax.com...
> On 26 Jul 2005 10:16:31 -0700, "db" < deepakbadki@rediffma
il.com>
> wrote:
>
>
> Oracle != sqlserver, so there is no 'timeout attribute'
>
>
> --
> Sybrand Bakker, Senior Oracle DBA

Even though the honorable Sir Sybrand Bakker saw fit to flame you for asking
such an offensive question, I will answer your query.
No, there is no timeout parameter in the connection string. There is,
however, an IDLE_TIME phrase in the CREATE PROFILE command. CONNECT_TIME
may also be of interest. Look up information on creating and assigning
profiles in the administrator's guide and refer to the SQL reference for the
correct syntax in creating a profile.

Also check out Oracle Net Manager=>Profile=>General tab=>Advanced=>TNS Time
out Value.

And please don't compare Oracle to SQL Server again. It's bad etiquette.

Hope this helps this and future postings.

--
Andreas
Oracle 9i Certified Professional
Oracle 10g Certified Professional
Oracle 9i Certified PL/SQL Developer

"If you don't eat your meat, you cannot have any pudding.
"How can you have any pudding if you don't eat your meat?!?!"
---

WARNING:
DO NOT REPLY TO THIS EMAIL
Reply to me only on this newsgroup

Andy Hassall

2005-07-26, 8:23 pm

On 26 Jul 2005 10:16:31 -0700, "db" < deepakbadki@rediffma
il.com> wrote:

>In sql, we can specify timeout attribute in connection string. In the
>similar way , does oracle allow to specify timeour parameter in
>connection string?.........If yes then plse let me know the connection
>string with timeout attribute.

Not as far as I'm aware, but you may want to look at
SQLNET. INBOUND_CONNECT_TIME
OUT in sqlnet.ora.

http://download-uk.oracle.com/docs/...t.htm#sthref481

Or at the OCI level, you could presumably use OCIBreak in a SIGALRM handler.

--
Andy Hassall / <andy@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool

Mark D Powell

2005-07-26, 8:23 pm

db, The SQL standard does not specify a connect string so you must be
talking about another rdbms product rather than SQL. If you are going
to post on the Oracle boards you should be sure that your post clearly
states what you want to know or are having a problem with. You should
always include the Oracle version involved. Many features and most
bugs are version dependent.

I know of no timeout parameter you can add to a connect string but any
such parameter would be Oracle version specific and likely would also
be dependent on the type of connection you were attempting: ODBC,
sqlplus, Pro*C, OCCI, Java thin client, etc....

HTH -- Mark D Powell --

Sponsored Links