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

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

Look up SYSTEM EVENT TRIGGERS in Morgan's Library at www.psoug.org and in the docs at http://tahiti.oracle.com.

Consider the AFTER SERVERERROR and BEFORE LOGOFF triggers.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org