Re: Can we write trigger on Oracle Database level for abnormal loss of connection to database?
Date: Fri, 29 Aug 2008 07:12:30 -0700
> 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“
> 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?
> 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.orgReceived on Fri Aug 29 2008 - 09:12:30 CDT