X-Received: by 10.13.215.4 with SMTP id z4mr6729316ywd.7.1457691689603; Fri, 11 Mar 2016 02:21:29 -0800 (PST) X-Received: by 10.182.19.129 with SMTP id f1mr99944obe.20.1457691689561; Fri, 11 Mar 2016 02:21:29 -0800 (PST) Path: news.netfront.net!news.glorb.com!y89no6750882qge.0!news-out.google.com!pn7ni6651igb.0!nntp.google.com!av4no36660igc.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: comp.databases.oracle.server Date: Fri, 11 Mar 2016 02:21:29 -0800 (PST) Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=108.171.128.165; posting-account=GzkNuQoAAACRWiw4R7gj6VICGdxsT5lk NNTP-Posting-Host: 108.171.128.165 User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: <989c1662-bc1d-4760-867b-b72225fdb77d@googlegroups.com> Subject: oracle 10.2.0.4 enterprise on windows client tracing From: chris.brown@coveainsurance.co.uk Injection-Date: Fri, 11 Mar 2016 10:21:29 +0000 Content-Type: text/plain; charset=ISO-8859-1 Xref: news.netfront.net comp.databases.oracle.server:2768 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