Re: triggers

Steve Howard wrote:
> schw wrote:
> > hi all,
> >
> > can one trigger be fired twice simultaneously ? I've got one trigger
> > that writes to a file and I'm worried that if the triggers is fired
> > twice simultaneously I end up with garbage in the file.
> >
> > what do you think?
> >
> > regards,
> > schw
>
> In a given session for a given operation it only fires once. If the
> table on which the trigger is based is heavily
> updated/deleted/inserted, or whatever event for which the trigger
> fires, it sounds from your description like you could have multiple
> sessions writing to your file at the same time. You can use DBMS_LOCK
> if you are writing to an external file and need to serialize access to
> it.
>
> HTH,
>
> Steve

Wouldn't this create a huge bottleneck? Received on Thu Nov 16 2006 - 12:14:48 CST