Does Oracle connection timeout and disconnect?

Hi all,

        I have a multi threaded (8 threads) application that uses Microsoft ODBC to communicate with Oracle 8. Each thread will connect to the Oracle, and each thread serves a client. Each time b4 a query is made, it checks 'Select 'X' from dual' to make sure that connection exists, if not, it will try to reconnect. The application runs fine after starting for a while. However, if I try to use the application the next day. The application will crash, even if I have only 1 client connecting to the application. I am wondering if the Oracle will time out the connection if there is inactivity for extended period of time, and terminate the connection? Does it? If not, how does it handles if there are app servers that 'hang' and still owning a connection? If many of these servers are repeatedly created and then hanged, would not there by many connections left hanging around?

        Hope someone could enlightened me.

        Regards

        Robert Received on Sat Apr 22 2000 - 00:00:00 CDT