Home » SQL & PL/SQL » SQL & PL/SQL » Oracle 10g, Win XP (Query Execution Time)
Oracle 10g, Win XP [message #387149] Wed, 18 February 2009 01:06 Go to next message
freakabhi
Messages: 74
Registered: November 2007
Location: mumbai
Member
All,

Is there any ways to find out the execution time of the query?
like exec + fetch time.

thanks,
freakabhi
Re: Oracle 10g, Win XP [message #387151 is a reply to message #387149] Wed, 18 February 2009 01:11 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
yes, no, maybe
what answer do you want?
Re: Oracle 10g, Win XP [message #387152 is a reply to message #387151] Wed, 18 February 2009 01:13 Go to previous messageGo to next message
freakabhi
Messages: 74
Registered: November 2007
Location: mumbai
Member
more of interested in "YES"
Re: Oracle 10g, Win XP [message #387153 is a reply to message #387151] Wed, 18 February 2009 01:14 Go to previous messageGo to next message
MarcS
Messages: 312
Registered: March 2007
Location: Antwerp
Senior Member
BlackSwan wrote on Wed, 18 February 2009 08:11
yes, no, maybe
what answer do you want?


I guess, what anyone else wants when posing a question, a decent answer?

@freakabhi: you could try searching for information about sql-tracing, tkprof, explain plan and the likes.
Don't be offended, but you're not the first one asking this - nor will you be the last one.

And when I say search I do mean search Wink
Re: Oracle 10g, Win XP [message #387155 is a reply to message #387149] Wed, 18 February 2009 01:20 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Use trace.

MHE
Previous Topic: How know the tables on which I have select access
Next Topic: Variable with many values
Goto Forum:
  


Current Time: Wed Dec 07 05:17:42 CST 2016

Total time taken to generate the page: 0.08747 seconds