IDLE_TIME disconnect?

We are porting our campus-wide data warehouse to Oracle 7.1 on AIX. Users with PC and Mac workstations will choose a familiar desktop product like Lotus, or Excell, or Paradox and connect to the read-only server using SQL*Net.

We would like to boot idle sessions off the server to make good use of our concurrent user licensing. The IDLE_TIME option in an Oracle profile does this, but it doesn't do it in a very friendly fashion. When the idle time limit is reached, Oracle aborts the session, but the client doesn't discover this until later, when another call to the server is attempted (and fails). It would really be far preferable for a user to discover their connection has been terminated more or less immediately, rather than discovering this after they've formulated another query.

Any ideas on how we could do this?

Jeff         Received on Wed May 24 1995 - 00:00:00 CEST