Home » SQL & PL/SQL » SQL & PL/SQL » measure the execution time for a query in PL/SQL (Pl/Sql Developer,10.2.03, Windows XP)
measure the execution time for a query in PL/SQL [message #315807] Tue, 22 April 2008 17:16 Go to next message
ambreen_fatima
Messages: 4
Registered: April 2008
Junior Member
If I were have to measure the execution time for a query in PL/SQL before actual executing it, so how can i do it?

Regards,
Ambreen
Re: measure the execution time for a query in PL/SQL [message #315808 is a reply to message #315807] Tue, 22 April 2008 17:22 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
You can't
Re: measure the execution time for a query in PL/SQL [message #315809 is a reply to message #315808] Tue, 22 April 2008 17:25 Go to previous messageGo to next message
ambreen_fatima
Messages: 4
Registered: April 2008
Junior Member
can't we do by explain plan? or when can we determine execution time of query
Re: measure the execution time for a query in PL/SQL [message #315810 is a reply to message #315809] Tue, 22 April 2008 17:27 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Quote:
when can we determine execution time of query

When you execute it.
Re: measure the execution time for a query in PL/SQL [message #315812 is a reply to message #315810] Tue, 22 April 2008 17:40 Go to previous message
ambreen_fatima
Messages: 4
Registered: April 2008
Junior Member
Thanks a lot.
Previous Topic: ??????Referential Integrity???????
Next Topic: Month Extracting
Goto Forum:
  


Current Time: Mon Dec 05 23:58:27 CST 2016

Total time taken to generate the page: 0.24394 seconds