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)