long running query across network

From: Ralf Fernan <ralphfernan.N0SPAM_at_yahoo.com>
Date: Tue, 12 Aug 2003 22:49:52 GMT
Message-ID: <kae_a.96315$3o3.6693430@bgtnsc05-news.ops.worldnet.att.net>

If a windows client (ODBC) initiates a long-running query to Oracle (AIX, 8.1.5), what are the reasons why the Oracle connection might be lost? I don't believe that 1) the application will close the connection simply because it is idle; 2) Oracle will close the connection while it is still processing the query. Besides a network "glitch" (whatever that is), are there reasons why the database connection might be dropped?

Thanks Received on Tue Aug 12 2003 - 17:49:52 CDT