Re: trace

jeff kish wrote:
>
> 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

select value from v$parameter where NAME = 'sql_trace'

if value = TRUE trace on

This works for trace turned on for the instance, im not sure how to work out if it is turned on via alter session statement. As for performance impact - the time taken will be lost in the overall server/network/client processes, but dont leave it on in a production system because there is an impact

-- 
Daryl Collins                          dcollins_at_csac.com
Computer Systems Authority  http://www.csac.com