Re: Triggers

From: The Magnet <>
Date: Tue, 8 Sep 2009 09:28:30 -0700 (PDT)
Message-ID: <>

On Sep 8, 11:20 am, ddf <> wrote:
> On Sep 8, 11:05 am, The Magnet <> wrote:
> > Hi,
> > Probably a nutty question, but, is it possible to find out what
> > program contained the DML which fired the trigger?
> > We have a particular situation, and next to mining the logs, we're not
> > sure how to find who or what is updating a certain row.  So, we should
> > a trigger on the table testing for this particular user ID and
> > capturing information is the best way to go.
> > If there are others, I'm all ears.
> You could set event 10046 at the instance level, but that would be
> overkill, I think.  An after update trigger would work, provided you
> populate an auditing table with the desired information.  You'll need
> to regularly monitor the table for size, unless this is a 'one-shot'
> event where once you find the 'cuplrit' you disable the trigger.
> Of course others may have differing opinions.
> David Fitzjarrell

Thanks David. The only thing is that we're looking for the program name. Say it is an external application with a direct DML statement. Would that appear in PROGRAM or CLIENT INFO of V$SESSION? Received on Tue Sep 08 2009 - 11:28:30 CDT

Original text of this message