Home » SQL & PL/SQL » SQL & PL/SQL » servererror trigger, can it hurt me? (10gr2)
servererror trigger, can it hurt me? [message #309788] Fri, 28 March 2008 16:05 Go to next message
Kevin Meade
Messages: 2102
Registered: December 1999
Location: Connecticut USA
Senior Member
I am looking to implement an after servererror trigger in my production databases. I have so far not had any problems with this type of trigger but I know the world is a much bigger place than my company.

so I am wondering if anyone has seen issues that I should avoid with this trigger. So far I have read the following:

1) lots of errors can potentially slow down a system (hmm.. if I am getting that many errors then there is something more serious to worry about I think, but thanks)

2) some errors by there nature may mean potential trouble for the servererror trigger itself. For example, memory errors and out of space errors. If the trigger is not KEPT, then it most likely must be loaded but an out of memory error may prevent this. Also, if writing errors to a table and the tablespace cannot extend when needed, again the trigger will fail (ok again hmm.. logical, but these errors are also reflective of bigger issues so I am not too worried about the servererror trigger being the cause of problems in these situations).

What else can the experienced crowd here tell me? Why should I not put this trigger on my production databases?


[Updated on: Fri, 28 March 2008 16:05]

Report message to a moderator

Re: servererror trigger, can it hurt me? [message #309822 is a reply to message #309788] Sat, 29 March 2008 01:32 Go to previous message
Michel Cadot
Messages: 65085
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I installed servererror trigger from time to time and I'm not worry about it because this trigger is always simple (just logging, what can you do?) and if an unexpected error raises during its execution, I know this error will raise soon after in an other program/process.
So it is more a detector of problems than a maker of problems and is useful for this as the error does not raise inside the functional code.

Just my 2 cents.

Previous Topic: creation of a folder and loading data by using procedure
Next Topic: How to create month?
Goto Forum:

Current Time: Sun Jul 23 17:46:46 CDT 2017

Total time taken to generate the page: 0.09005 seconds