Is is possible turn on timed_statistics to other session?

From: <lsantos_at_pobox.com>
Date: 2000/03/22
Message-ID: <8bbb3l$nag$1@nnrp1.deja.com>#1/1

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