Re: Trigger for Disconnected (crashed) Session?
Date: Thu, 10 Jul 2014 13:06:57 -0700 (PDT)
Message-ID: <7ef22773-2c25-46fd-b4f4-9956ab963eb2_at_googlegroups.com>
On Wednesday, July 9, 2014 9:14:40 AM UTC-4, Robinson Road wrote:
> 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.
Ed, I recommend Cadot's approach. Set up a task to monitor the pipe reader and issue a warning if it is not running.
HTH -- Mark D Powell -- Received on Thu Jul 10 2014 - 22:06:57 CEST