Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: About getting real time of user application discinnect
Hi
this is a BEFORE LOGOFF trigger - implies that there must be some 'legal' log off to fire the trigger. Pull the plug - wont fire the trigger. I don't know of any means to catch 'illegal' disconnects.
/Svend
Vitaliy Ogiychuk wrote:
> 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 - 15:49:25 CST