| Problem with SQL Trace Command [message #38651] |
Fri, 03 May 2002 06:35  |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
