Re: trace

In article <5l7rpo$elf_at_chronicle.concentric.net>, jeff kish <ait_at_concentric.net> writes
>Is it possible for an application to determine that SQL_TRACE is
>turned on? I am trying to trouble shoot a performance problem at a
>customer site and am wondering if SQL_TRACE might be turned on.
>
>If it is could it be causing a performance impact?
>
>Thanks,
>
>Jeff Kish
>ait_at_concentric.net
>

From within the application try the query;

"select value from sys.v$parameter where name = 'sql_trace';"

if "value" is "true" this means that sql tracing is switched on database wide.
For an individual session, you can set tracing on by executing a query like "alter session set sql_trace true;" and off by executing "alter session set sql_trace false;"  

-- 
Bola Ogunlana