Home » Other » Client Tools » Problem with SQL Trace Command
Problem with SQL Trace Command [message #38651] Fri, 03 May 2002 06:35 Go to next message
hug
Messages: 6
Registered: May 2002
Junior Member
Hi,

I'm actually create a application that access a Oracle Database. In order to know if my application work well I want to compare the time needed by the application to execute a query and the time needed by oracle to execute the corresponding query.
In order to do that thing, I want to use SQL Trace.
Normally SQL Trace create a output file who's contains the time needed for executing the query.
But I don't have a output file. I've searching on my computer all the files who have a trc extension (the format of the output file), and I don't have any file corresponding ...

So if anybody knows where can be the problem thanks to respond ...

Hug
Re: Problem with SQL Trace Command [message #38652 is a reply to message #38651] Fri, 03 May 2002 07:04 Go to previous message
Rick Cale
Messages: 111
Registered: February 2002
Senior Member
Oracle will the trace file in your USER_DUMP_DEST
destination. Check to see if location set in
USER_DUMP_DEST is valid. If it is start sqlplus
and set sqltrace on and issue a command. Check
to see if .trc file is in USER_DUMP_DEST.
Previous Topic: splitting and associating part of a field
Next Topic: EMail from Oracle
Goto Forum:
  


Current Time: Fri Mar 29 10:51:17 CDT 2024