Re: Triggers
From: The Magnet <art_at_unsu.com>
Date: Tue, 8 Sep 2009 09:28:30 -0700 (PDT)
Message-ID: <73fc8b58-5174-43a9-964e-f5d733702270_at_w36g2000yqm.googlegroups.com>
On Sep 8, 11:20 am, ddf <orat..._at_msn.com> wrote:
> On Sep 8, 11:05 am, The Magnet <a..._at_unsu.com> 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
Date: Tue, 8 Sep 2009 09:28:30 -0700 (PDT)
Message-ID: <73fc8b58-5174-43a9-964e-f5d733702270_at_w36g2000yqm.googlegroups.com>
On Sep 8, 11:20 am, ddf <orat..._at_msn.com> wrote:
> On Sep 8, 11:05 am, The Magnet <a..._at_unsu.com> 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