Re: trace every SQL statement of a specific user

On 7 mar, 15:10, Inquirer <sdama..._at_gmail.com> wrote:
> I've already tried it and it worked, thank you.
> at the risk of being too boring (I guess I already am)
> the only thing that I'd need for complete satisfaction
> would be now to limit the tracing to a certain machine.
>
> let's imagine such a situation: there are several copies
> of some software in some company. some of them
> have to run continuously. but then I'd like to do some workflow
> on one machine and then get a trace only from this very machine,
> and this very oracle user. Or at least to be able to easily filter the
> trace
> file for events only from that machine...
>
> I thought about an extension of the trigger with something like:
> if user_logging_on_not_from_machine_xxx then return;... this would
> already
> make me totally satisfied.
> Greetings

Change the trigger so that it enables tracing only if your particular condition is met, by checking the value of the proper parameter with sys_context('userenv',xxxx). Received on Sat Mar 08 2008 - 03:32:08 CST