Re: trace every SQL statement of a specific user

From: Inquirer <>
Date: Fri, 7 Mar 2008 06:10:42 -0800 (PST)
Message-ID: <>

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 Received on Fri Mar 07 2008 - 08:10:42 CST

Original text of this message