Re: How to create a trace file for TKPROF

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Fri, 15 Nov 2002 21:08:58 +0100
Message-ID: <5tkatu0db2ffum8lerk9o50ip4j8ivr8u2_at_4ax.com>

On Fri, 15 Nov 2002 11:05:54 -0800, Tony Garrido <syster_at_sys.com> wrote:

>
>How do you create a tracefile for tkprof to read?
>
>Sincerely,
>
>Tony Garrido

By enabling sql_trace for the database or for the session as outlined in the performance tuning manual. Refer to 'alter session set sql_trace = true'

Basically, this question would have been prevented if you would only have searched for 'TKPROF' on http://tahiti.oracle.com

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Nov 15 2002 - 21:08:58 CET

This message: [ Message body ]
Next message: Sybrand Bakker: "Re: DDL Commands"
Previous message: Sybrand Bakker: "Re: Which table holds the view cols?"
In reply to Tony Garrido: "How to create a trace file for TKPROF"
Next in thread: Ban Spam: "Re: How to create a trace file for TKPROF"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message