Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

What the unit of cost in explain plan

569820Apr 11 2007 — edited Apr 11 2007
Can somebody tell me what is the unit of 'cost' which we see in the explain plan of a query. I know there can be tree types of costs. (1) CPU usage, (2) Memory usage and (3) Disk I/O.

Now when we see the explain plan of a query, it shows the cost of each step in the plan, my question is "in what terms is this cost specified?" is it cpu cost? or memory cost? or disk I/O cost?.

I have also noticed that sometimes a stem with higher cost is completed earlier than a step with lower cost. what does this mean?

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 9 2007
Added on Apr 11 2007
2 comments
1,016 views