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

From: DA Morgan <>
Date: Fri, 29 Aug 2008 07:12:30 -0700
Message-ID: <>

shilpa wrote:
> 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.

Look up SYSTEM EVENT TRIGGERS in Morgan's Library at and in the docs at

Consider the AFTER SERVERERROR and BEFORE LOGOFF triggers.

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Fri Aug 29 2008 - 09:12:30 CDT

Original text of this message