OraFAQ Forum: Client Tools » Problem with SQL Trace Command

Home » Other » Client Tools » Problem with SQL Trace Command

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

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.

Report message to a moderator

Previous Topic:	splitting and associating part of a field
Next Topic:	EMail from Oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 01 09:01:40 CDT 2025