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?
>
> Thanks,
> Jeff Kish
> ait_at_concentric.net
try this:
select * from v$parameter where lower( name) = 'sql_trace';
You should have the SELECT - privilege on the v$parameter - view or the
SELECT ANY TABLE privilege.
Of course SQL_TRACE = TRUE hits your performance.....
franz.lindsberger_at_siemens.at
Received on Tue May 13 1997 - 00:00:00 CDT
