Re: enable sql trace on users

Teresa,

turn on sql_trace on Logon system level trigger for the users you need to trace e.g.

if (user='blah') then

     execute immediate 'alter session set sql_trace=true'; end if;

Teresa wrote:

> I would liek to set up sql tracing on some users, can someone please
> tell me how can I do it. I needed in order to view how many times some
> users are connecting to the database then I need to set up user
> profiles for that specific users that are taking to many connections.
> Any ideias would be great
> Thanks
> Teresa
>

-- 
hth,
Stan