Home » RDBMS Server » Performance Tuning » Query execution estimation (Oracle 10g HP Unix)
Query execution estimation [message #340308] Tue, 12 August 2008 04:57 Go to next message
santoshorcl
Messages: 24
Registered: August 2007
Location: pune
Junior Member

Hi all,
could you please tell me how to estimate query execution time using explain plan.

Thanks in advance,
Santy.
Re: Query execution estimation [message #340311 is a reply to message #340308] Tue, 12 August 2008 05:16 Go to previous messageGo to next message
Olivia
Messages: 519
Registered: June 2008
Senior Member
sql> set timing on

Regards,
Oli
Re: Query execution estimation [message #340316 is a reply to message #340308] Tue, 12 August 2008 05:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
could you please tell me how to estimate query execution time using explain plan.

EXPLAIN PLAN FOR <your query>

Regards
Michel
Re: Query execution estimation [message #340325 is a reply to message #340316] Tue, 12 August 2008 05:50 Go to previous messageGo to next message
santoshorcl
Messages: 24
Registered: August 2007
Location: pune
Junior Member

Hi Michel,
I agree with u. Thanks.
I know these all stapes.
Actually i need how much time any query can take for execution without executing it. I can use only explain plan.
for your reference please see the attachment.

Is it possible to calculate approx estimated time for query execution?

Thanks in advance,
Santy.

[Updated on: Tue, 12 August 2008 05:53]

Report message to a moderator

Re: Query execution estimation [message #340326 is a reply to message #340325] Tue, 12 August 2008 05:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
See you explain plan, time column: 07:24:50

Regards
Michel
Re: Query execution estimation [message #340329 is a reply to message #340326] Tue, 12 August 2008 06:05 Go to previous messageGo to next message
santoshorcl
Messages: 24
Registered: August 2007
Location: pune
Junior Member

Thanks Michel.

You mean to say it will complete it's run in approx 07 hours. But i saw many times queries are taking more time than this explain plan time. Can i believe on it or not?

Is there any other way?
Re: Query execution estimation [message #340343 is a reply to message #340329] Tue, 12 August 2008 07:19 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is an estimation.
There is no way to know what it will be, above all for severak hours statement.

Regards
Michel
Previous Topic: Source of views
Next Topic: What it suggests?
Goto Forum:
  


Current Time: Sat Dec 03 14:16:03 CST 2016

Total time taken to generate the page: 0.07561 seconds