OraFAQ Forum: Performance Tuning » Query execution estimation

Home » RDBMS Server » Performance Tuning » Query execution estimation (Oracle 10g HP Unix)

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

Query execution estimation [message #340308]

Tue, 12 August 2008 04:57

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.

Report message to a moderator

Re: Query execution estimation [message #340311 is a reply to message #340308]

Tue, 12 August 2008 05:16

Olivia
Messages: 519
Registered: June 2008

Senior Member

sql> set timing on

Regards,
Oli

Report message to a moderator

Re: Query execution estimation [message #340316 is a reply to message #340308]

Tue, 12 August 2008 05:28

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Query execution estimation [message #340325 is a reply to message #340316]

Tue, 12 August 2008 05:50

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.

Attachment: Customer_query.txt
(Size: 12.29KB, Downloaded 1238 times)

[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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

See you explain plan, time column: 07:24:50

Regards
Michel

Report message to a moderator

Re: Query execution estimation [message #340329 is a reply to message #340326]

Tue, 12 August 2008 06:05

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?

Report message to a moderator

Re: Query execution estimation [message #340343 is a reply to message #340329]

Tue, 12 August 2008 07:19

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	Source of views
Next Topic:	What it suggests?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 15:04:02 CST 2024