Re: Is is possible turn on timed_statistics to other session?

Timed statistics is a global, systemwide setting. The performance penalty is not noticeable.
IMO you should have it on ALWAYS.

Regards,

Sybrand Bakker, Oracle DBA

<lsantos_at_pobox.com> wrote in message news:8bbb3l$nag$1_at_nnrp1.deja.com...
> Hi,
> When I want to debug for performace some job of my users, I ask
> them to put the famous ALTER SESSION SET TIMED_STATISTICS=TRUE and
> ALTER SESSION SET SQL_TRACE=TRUE;
> When I have a problem with a external package, where is not
> possible execute these commands, I use the procedure
> SET_SQL_TRACE_IN_SESSION of the DBMS_UTILITY package.
> Well, with this approach I have the trace file, but without the
> timed statistics option.
> I can just obtain this info if if issue a ALTER SYSTEM SET
> TIMED_STATISTICS=TRUE in all server.
> Is there a way to turn the timed_statistics to just one session, as
> the sql_trace option?
> Best regards
> Luis Santos
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Mar 22 2000 - 00:00:00 CST