Timed statistics and SQL_TRACE for already running session

From: <Cherie_Machler_at_gelco.com>
Date: Wed, 08 Aug 2001 07:48:15 -0700
Message-ID: <F001.003642AA.20010808071300@fatcity.com>

I used the following syntax/package to run a trace on a user's already running
session.

EXECUTE dbms_system.set_sql_trace_in_session(8,12,TRUE);

I then ran tkprof on the resulting trace file. It all worked fairly well but
I didn't get any times on any of the statements that executed.

Is there a way to use timed_statistics with this package? Or must I turn on timed statistics for the entire database?

The user is using a canned application so there is no way for him to alter his session and set timed_statistics before he starts his work. Is there any way that I can alter his session and turn on timed_statistics for just his session?

Thanks for any clever ideas,

Cherie Machler
Oracle DBA
Gelco Information Network

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Cherie_Machler_at_gelco.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Aug 08 2001 - 09:48:15 CDT