Re: Automize SQL TRACE OPERATION

Pete,

Nice paper. I've added it to my favorites list. I haven't used any of the 10G dbms_support features.

Mark Simmons
Sr. Oracle DBA
Sabre-Holdings, Southlake, TX

Pete Finnigan <plsql_at_petefinnigan.com> wrote in message news:<lHlJZFBAVZTARx+g_at_peterfinnigan.demon.co.uk>...
> Hi Bill,
>
> You can check in the after logon trigger for the username or sid, serial
> etc. Have a look at a paper i wrote recently that describes many ways to
> enable trace in Oracle. There is an example of a logon trigger that
> checks which user is calling it. In my example I just check its not SYS
> or SYSTEM but you can change that and check in anyway you want. The
> paper is http://www.petefinnigan.com/ramblings/how_to_set_trace.htm
>
> hth
>
> kind regards
>
> Pete
Received on Tue Mar 09 2004 - 11:30:22 CST