Re: Is thjere a way to find all sql satements run by a session

On version 9.2 the Oracle audit feature does not capture the actual SQL statement executed in the audit trail so while auditing can be used to see all objects a session touched and the type of SQL statement issued it will not capture the level of detail requested in the OP's post.

Setting trace on from another session will only trace SQL statements ran after the trace is set on so I think the only practical solution is to set trace on when the session of interest starts. If the actual user task cannot be modified to set trace on then perhaps a database logon event trigger could be used.

HTH -- Mark D Powell -- Received on Sat Mar 25 2006 - 12:29:49 CST