CREATE PROFILE

From: Richard Hennessy <rhennessy_at_becker-software.com>
Date: 1997/03/10
Message-ID: <33241399.2BCB@becker-software.com>#1/1

Hi,

I have a problem with IDLE_TIME.

I created a PROFILE with an IDLE_TIME specification of 2 (minutes) and created a user with this profile.
I logged on using the new user and deleted rows from a table, then I turned my pc off (I know, I know, but it´s only a test !!) my session was INACTIVE but the locks on the table were still there even after two hours !! Am I misunderstanding the meaning IDLE_TIME or is there something else wrong ? At what stage, if any, does Oracle realise my session is dead and is not going to come back to life ??

Anyone got any ideas ?

TIA
Richard Hennessy
Becker Software, Wiesbaden

Oracle runs on HP-UX, client is windows PC via TCP/IP. Received on Mon Mar 10 1997 - 00:00:00 CST