I have a trigger
CREATE OR REPLACE TRIGGER TBL_DISCONNECT BEFORE LOGOFF DATABASE
DECLARE
SID NUMBER;
BEGIN
SELECT USERENV('SESSIONID') INTO SID FROM DUAL;
INSERT INTO USERID(SID, LOGOFF_TIME)
VALUES (SID, SYSDATE);
END;
The trigger insert time of application disconnect in specified table. But
the trigger fires only if application terminated successfully.
Question: how Oracle may determine that application was break (such as pull
out the network cable or shutdown the user's terminal) and set it disconnect
time without waiting of killing application session by PMon?
Received on Mon Oct 28 2002 - 09:33:06 CST
