dbTalk Databases Forums  

Can we write trigger on Oracle Database level for abnormal loss ofconnection to database?

Go Back dbTalk Databases Forums Databases comp.databases.oracle.misc Can we write trigger on Oracle Database level for abnormal loss ofconnection to database?

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss Can we write trigger on Oracle Database level for abnormal loss ofconnection to database? in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
shilpa
 
Posts: n/a

Default Can we write trigger on Oracle Database level for abnormal loss ofconnection to database? - 08-29-2008 , 08:53 AM





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.

Reply With Quote
  #2  
Old   
DA Morgan
 
Posts: n/a

Default Re: Can we write trigger on Oracle Database level for abnormal lossof connection to database? - 08-29-2008 , 09:12 AM





shilpa wrote:
Quote:
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org


Reply With Quote
  #3  
Old   
DA Morgan
 
Posts: n/a

Default Re: Can we write trigger on Oracle Database level for abnormal lossof connection to database? - 08-29-2008 , 09:12 AM


shilpa wrote:
Quote:
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org


Reply With Quote
  #4  
Old   
DA Morgan
 
Posts: n/a

Default Re: Can we write trigger on Oracle Database level for abnormal lossof connection to database? - 08-29-2008 , 09:12 AM


shilpa wrote:
Quote:
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org


Reply With Quote
  #5  
Old   
DA Morgan
 
Posts: n/a

Default Re: Can we write trigger on Oracle Database level for abnormal lossof connection to database? - 08-29-2008 , 09:12 AM


shilpa wrote:
Quote:
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org


Reply With Quote
  #6  
Old   
sybrandb@hccnet.nl
 
Posts: n/a

Default Re: Can we write trigger on Oracle Database level for abnormal loss of connection to database? - 08-29-2008 , 09:52 AM


On Fri, 29 Aug 2008 06:53:58 -0700 (PDT), shilpa
<shilpa.uttarwar (AT) gmail (DOT) com> wrote:

Quote:
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.

Please do not multipost or crosspost.
Most people responding here monitor the entire comp.database.oracle
hierarchy.
Also someone might have responded in a different group, and others do
not see his answer.

--
Sybrand Bakker
Senior Oracle DBA


Reply With Quote
  #7  
Old   
sybrandb@hccnet.nl
 
Posts: n/a

Default Re: Can we write trigger on Oracle Database level for abnormal loss of connection to database? - 08-29-2008 , 09:52 AM


On Fri, 29 Aug 2008 06:53:58 -0700 (PDT), shilpa
<shilpa.uttarwar (AT) gmail (DOT) com> wrote:

Quote:
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.

Please do not multipost or crosspost.
Most people responding here monitor the entire comp.database.oracle
hierarchy.
Also someone might have responded in a different group, and others do
not see his answer.

--
Sybrand Bakker
Senior Oracle DBA


Reply With Quote
  #8  
Old   
sybrandb@hccnet.nl
 
Posts: n/a

Default Re: Can we write trigger on Oracle Database level for abnormal loss of connection to database? - 08-29-2008 , 09:52 AM


On Fri, 29 Aug 2008 06:53:58 -0700 (PDT), shilpa
<shilpa.uttarwar (AT) gmail (DOT) com> wrote:

Quote:
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.

Please do not multipost or crosspost.
Most people responding here monitor the entire comp.database.oracle
hierarchy.
Also someone might have responded in a different group, and others do
not see his answer.

--
Sybrand Bakker
Senior Oracle DBA


Reply With Quote
  #9  
Old   
sybrandb@hccnet.nl
 
Posts: n/a

Default Re: Can we write trigger on Oracle Database level for abnormal loss of connection to database? - 08-29-2008 , 09:52 AM


On Fri, 29 Aug 2008 06:53:58 -0700 (PDT), shilpa
<shilpa.uttarwar (AT) gmail (DOT) com> wrote:

Quote:
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.

Please do not multipost or crosspost.
Most people responding here monitor the entire comp.database.oracle
hierarchy.
Also someone might have responded in a different group, and others do
not see his answer.

--
Sybrand Bakker
Senior Oracle DBA


Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top