oracle 10.2.0.4 enterprise on windows client tracing
From: <chris.brown_at_coveainsurance.co.uk>
Date: Fri, 11 Mar 2016 02:21:29 -0800 (PST)
Message-ID: <989c1662-bc1d-4760-867b-b72225fdb77d_at_googlegroups.com>
I am interested in capturing sql statements/info from an identified session
Date: Fri, 11 Mar 2016 02:21:29 -0800 (PST)
Message-ID: <989c1662-bc1d-4760-867b-b72225fdb77d_at_googlegroups.com>
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