Re: Can we trigger event for abnormal loss of connection to oracle databse?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Fri, 29 Aug 2008 07:04:03 -0700 (PDT)
Message-ID: <1f824ea8-1ed6-4ff2-a95a-8b3edda78365@34g2000hsh.googlegroups.com>


On Aug 29, 9:56 am, shilpa <shilpa.uttar..._at_gmail.com> wrote:
> ORACLE Database :
>
> 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?
>
> Any comments/suggestions would be appreciated.
>
> Thanks..

The view v$session is written on an x$ view and you cannot define triggers on the x$ view which are actually program structures in memory. You cannot define triggers on the physical Oracle database base tables owned by SYS either.

You can look to see if the database event trigger ON ERROR might be of any use.

HTH -- Mark D Powell -- Received on Fri Aug 29 2008 - 09:04:03 CDT

Original text of this message