Re: trace and tkprof

ait_at_concentric.net (jeff kish) wrote:

>Hello!
>
>I have a customer with some complaints regarding performance.
>We found out that SQL*Net logging was turned on and left on which
>evidently bombs performance.
>
>I wonder now if perhaps they also have SQL_TRACE turned on for their
>server, or at least some sessions. Is there some way I can determine
>from within a pro-c application I have written that this is the case
>so I could inform them?
>
>Could SQL_TRACE be responsible for some marginal performance losses?

Could be. Query the V$PARAMETER view to see if it's on -

SELECT value FROM V$PARAMETER WHERE name = 'sql_trace';

--
Chuck Hamilton
chuckh_at_dvol.com

If at first you don't succeed, skydiving isn't for you.