Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: triggers
extents wrote:
> Hi
> Is there a way to find out how many times a trigger has been fired
> during a given time?
>
> ta
CREATE TABLE trigger_audit (
times_fired NUMBER,
when_fired TIMESTAMP DEFAULT SYSTIMESTAMP);
Alter your trigger to incude an update of the times_fired column.
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Mon Feb 13 2006 - 11:31:47 CST