Re: Trigger for Disconnected (crashed) Session?

"Robinson Road" <voyager1space_at_gmail.com> a écrit dans le message de news: b0a9d8d2-4940-412b-912e-f77504810085_at_googlegroups.com... Hi,

we have a process that uses DBMS_PIPES and has to have a constant connection to the database (11.2) from another server.

Certain things will obviously cause that connection to close like a shutdown and someone not remembering to start the connection (though I guess that could be automated) but also other things like a file system filling up on the connecting server or the account locking, etc.

Is there a trigger or something similar that could email if the session isn't present for whatever reason.

I thought at first a logoff trigger but my understanding is that it won't fire if the session crashes.

Thanks,

Ed.

No trigger but you can just schedule a job every minute to check if the session is there.

Regards
Michel Received on Wed Jul 09 2014 - 21:54:26 CEST