Re: Can we write trigger on Oracle Database level for abnormal loss of connection to database?

From: <sybrandb_at_hccnet.nl>
Date: Fri, 29 Aug 2008 16:52:32 +0200
Message-ID: <773gb4hqv0m6vefb3b7jun92sh45idfpvf@4ax.com>


On Fri, 29 Aug 2008 06:53:58 -0700 (PDT), shilpa <shilpa.uttarwar_at_gmail.com> wrote:

>ORACLE:
>
>I want a trigger to get fired when my application’s connection to the
>database gets disconnected abnormally.
>
>I plan to monitor the Server Name and its status in the “ v$session“
>table.
>
>Can I write a trigger that gets fired when “ v$session“ table gets
>edited? How can I achieve it?
>
>Is there any other way to execute a stored procedure and perform some
>steps when a connection is lost to a database?
>
>Thanks...
>
>Any comments/suggestions would be appreciated.

Please do not multipost or crosspost.
Most people responding here monitor the entire comp.database.oracle hierarchy.
Also someone might have responded in a different group, and others do not see his answer.

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Fri Aug 29 2008 - 09:52:32 CDT

Original text of this message