Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: triggers

Re: triggers

From: EdStevens <quetico_man_at_yahoo.com>
Date: 16 Nov 2006 10:14:48 -0800
Message-ID: <1163700888.340155.181960@i42g2000cwa.googlegroups.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US