Re: SQL trace for specific database user
- From: David Sharples <davidsharples@xxxxxxxxx>
- To: ora_forum@xxxxxxxxx
- Date: Fri, 16 Dec 2005 15:38:02 +0000
just find his session in v$session and use the sid / serial# to trace it
Or do a logon trigger to start a trace everytime he logs on
On 12/16/05, ora_forum <ora_forum@xxxxxxxxx> wrote:
>
> Is it possible to trace specific database user? This user connecting to
> the database from application and I need to know all SQL he is running. I
> can't find any information in v$sqlarea and v$sqltext for him.
>
Other related posts:
