Re: oracle 10.2.0.4 enterprise on windows client tracing

On Fri, 11 Mar 2016 02:21:29 -0800, chris.brown wrote:

> I am interested in capturing sql statements/info from an identified
> session
>
> I have been using following examples ( with sid,serial as params )
>
> exec
> dbms_system.set_bool_param_in_session(137,1832,'timed_statistics',true);
>
> exec
> dbms_system.set_int_param_in_session
(137,1832,'max_dump_file_size',2147483647);
>
>
>
> exec dbms_system.set_sql_trace_in_session(137,1832,true);
>
> I have only got this to work when I have had access to the session in
> question to alter the sql_trace variable, but I can't do this for
> someone else's session.
>
>
> I understand that these procedures are not supported by oracle , so I
> wondered if anyone had experience of getting the above method working or
> maybe using an alternative approach
>
> regards Chris B

Get yourself a DBA or SYSDBA session. That should do the trick

-- 
Mladen Gogala
The Oracle Whisperer
http://mgogala.byethost5.com