Re: SQL Trace at concurrent program level

From: Rajiv Iyer <raju.rgi_at_gmail.com>
Date: Thu, 2 May 2013 17:09:14 +0530
Message-ID: <CADxvSwNhJwi-+q939mJ5MBsdJs60dYy2+WMbCLkx=W-78+WYyg_at_mail.gmail.com>

Hi Bala.
Is it the same session that is generating the trace? Please check for SQL_TRACE column in v$session.
Also it is possible that trace might be enabled at profile level in Oracle apps. Please check in FND_PROFILE_OPTIONS_VL view for profile_option_name like '%AFLOG_ENABLED%' or profile_option_name like '%FND_INIT_SQL%' and disable it.

Regards,
Rajiv.

On Thu, May 2, 2013 at 4:01 PM, Bala Krishna <krishna000_at_gmail.com> wrote:

> Hi All,
> Our application delvelopers have enabled a sql trace at concurrent program
> level.I've found the session of that and disabled a sql trace for that
> session at the backend using dbms_system pkg but in vian although i have
> disabled the treace but i could see that its still generating a trace for
> that session ..
>
> Any idea's pleaes appreicated ?
>
> Regards
> Bala
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu May 02 2013 - 13:39:14 CEST