Re: INIT.ORA Parameters

From: Jan Coekelberghs <jan.coekelberghs_at_ping.be>
Date: 1998/01/19
Message-ID: <34c3b426.922785@news.belgium.eu.net>#1/1

On 19 Jan 1998 06:56:03 GMT, "Pei L. Ku" <pku_at_gte.net> wrote:

>1. you can turn sql trace on at the session level, but only from the
>session itself. The SQL to issue is 'alter session set sql_trace=true'.
>To end sql trace from a session, 'alter session set sql_trace=true'. If
>you can't get to the app code (say you bought a package) and the app does
>not provide a backdoor for you to issue SQLs, then you are stuck with
>global sql_trace in init.ora. I'm still waiting for Oracle to implement a
>machenism that the DBA can use to turn sql trace on for a specific user
>session...

This already exists for some years (starting in 7.2).

Execute dbms_system.set_sql_trace_in_session(sid, serial#, true) will turn the trace on. False will turn it off again.

Jan Received on Mon Jan 19 1998 - 00:00:00 CST