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

From: Palooka <nobody_at_nowhere.com>
Date: Fri, 29 Aug 2008 19:46:47 +0100
Message-ID: <suXtk.122266$6s4.121736@newsfe14.ams2>

fitzjarrell_at_cox.net wrote:
> Comments embedded.
> On Aug 29, 10:28 am, Mark D Powell <Mark.Pow..._at_eds.com> wrote:

>> On Aug 29, 10:50 am, sybra..._at_hccnet.nl wrote:
>>
>>
>>
>>
>>
>>> On Fri, 29 Aug 2008 06:56:36 -0700 (PDT), 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..
>>> audit connect will do the trick automagically.
>>> It records the error status at every disconnect.
>>> 0 for normal disconnect, non-zero for all others.
>>> --
>>> Sybrand Bakker
>>> Senior Oracle DBA- Hide quoted text -
>>> - Show quoted text -
>> Question, isn't the command "audit session" rather than audit connect?
>>

>
> In 9.2.0 and later releases the AUDIT CONNECT statement is valid.
>

>> In my past experience auditing sessions if the session terminated
>> abnormally there was no disconnect entry in the audit trail.  I have
>> not used the command since 8.1.7 but I am pretty sure this is still
>> true on 9.2.  I do not know about with 10g+

>
> Provided audit_trail is set to DB the DBA_AUDIT_SESSION view will
> provide the logoff_time and the returncode, which will be non-zero for
> abnormally terminated sessions. And this applies to databases from
> 9.2.0.x onwards.
> .

>> HTH -- Mark D Powell --- Hide quoted text -
>>
>> - Show quoted text -

>
>
> David Fitzjarrell

One wonders though what OP is trying to achieve exactly. Why is he wondering about abnormal disconnects? Is it perhaps because the application is buggy?

Palooka Received on Fri Aug 29 2008 - 13:46:47 CDT