Home » RDBMS Server » Performance Tuning » Explain Plan (Oracle Database 10g Release - 64bi ,HP-UX B.11.23)
Explain Plan [message #397810] Tue, 14 April 2009 00:52 Go to next message
Messages: 56
Registered: October 2008
Location: Mumbai
Hello everyone, i want to know about the explain plan.When i execute the query explain plan for select * from dual
and then execute select * from table(dbms_xplan.display)
then we got a structure so in this concern i would like to know what is the meaning of column 'cost(%cpu)' that is what is the measure of cost,how it is calculated and what is in the bracket(%cpu) what does this means to us and how it is measured ,also tell about which value among them to be remain as less possible for best execution plan.thnx in advance..
Re: Explain Plan [message #397821 is a reply to message #397810] Tue, 14 April 2009 01:13 Go to previous message
Michel Cadot
Messages: 65144
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Performance Tuning Guide
Chapter 19 Using EXPLAIN PLAN

Previous Topic: Bind variable versus CURSOR_SHARING='SIMILAR'
Next Topic: improving query performance
Goto Forum:

Current Time: Mon Aug 21 01:44:41 CDT 2017

Total time taken to generate the page: 0.01216 seconds