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.
>

References:

SQL trace for specific database user
From: ora_forum

Re: SQL trace for specific database user

Other related posts: