Re: Connection close by oracle server

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Wed, 28 Apr 2004 17:41:32 +0200
Message-ID: <n2kv80dk2dcm3ubd0besjn781enuksi3o8@4ax.com>

On Wed, 28 Apr 2004 11:35:58 +0200, Josef Böhm <josefboehm_at_daybyday.de> wrote:

>I have an client connect to the oracle server 8.1.7. After 12 hours the
>oracle close the connection to the client.
>The CONNECT_TIME and IDLE_TIME in the user profile is set to 'unlimited'
>but the connection is automaticly close after 12 hours.
>Is the an other parameter setting for this problem ?
>
>
>Josef Böhm

Likely this is being caused by the O/S. You may want to ask whether you don't want to run this directly on the server or optimize your program so that it doesn't have sql statement that run for 12 hours.

--
Sybrand Bakker, Senior Oracle DBA

Received on Wed Apr 28 2004 - 10:41:32 CDT