Re: SQL Trace at concurrent program level

  • From: Rajiv Iyer <raju.rgi@xxxxxxxxx>
  • To: krishna000@xxxxxxxxx
  • Date: Thu, 2 May 2013 17:09:14 +0530

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@xxxxxxxxx> 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
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>


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


Other related posts: