Home » RDBMS Server » Performance Tuning » Explain Plan (Oracle Database 10g Release 10.1.0.2.0 - 64bi ,HP-UX B.11.23)
Explain Plan [message #397810] Tue, 14 April 2009 00:52 Go to next message
vinniora
Messages: 56
Registered: October 2008
Location: Mumbai
Member
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: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Performance Tuning Guide
Chapter 19 Using EXPLAIN PLAN

Regards
Michel
Previous Topic: TKprof shows fetching taking long time
Next Topic: improving query performance
Goto Forum:
  


Current Time: Mon Dec 05 12:36:54 CST 2016

Total time taken to generate the page: 0.12442 seconds