Re: running TKPROF from an application layer

srivenu_at_hotmail.com (srivenu) wrote in message news:<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.

I am trying to trace and monitor costs of executing pl*sql blocks stored in the database (called from an application), but I do not want the application layer to effect those costs.

Thanks,
David Received on Wed Mar 06 2002 - 23:50:46 CET