Re: running TKPROF from an application layer

From: srivenu <srivenu_at_hotmail.com>
Date: 5 Mar 2002 21:59:21 -0800
Message-ID: <1a68177.0203052159.59b769ae_at_posting.google.com>

TKPROF is different from turning on SQL_TRACE in a session. If you turn on SQL_TRACE in a session, all SQL statements are traced to a file.
TKPROF is used to format that file.
Well you can turn the trace for the application session by using the DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION.
You can execute this procedure from SQL*PLUS For this you need the SID and SERIAL# of the Application session. You can query V$SESSION to get these values. Received on Wed Mar 06 2002 - 06:59:21 CET

This message: [ Message body ]
Next message: Ian Evans: "simple read-only snapshots or materialised views setting up and maintenance"
Previous message: David Van Horn: "running TKPROF from an application layer"
In reply to: David Van Horn: "running TKPROF from an application layer"
Next in thread: David Van Horn: "Re: running TKPROF from an application layer"
Reply: David Van Horn: "Re: running TKPROF from an application layer"

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

Original text of this message