What IS the cost of a query and what does it mean?This is a featured page

Platform: Oracle App: Tool:
DB Ver: 9.2 App Ver: Tool Ver:
Revision Date: 23-Nov-2006 Keywords: REF, REFERENCE, CBO,COST FORMULA
Reference Notes
The formula for the cost (using the CPU Costing Model) of a query is:

Cost = (
#SRds * sreadtime
+ #MRds * mreadtime
+ #CPUCycles / cpuspeed
) / sreadtime

where:
#SRds = number of single block reads
#MRds = number of multi block reads
#CPUCycles = number of CPU Cycles

sreadtim = single block read time
mreadtime = multi block read time
cpuspeed = Standard 'Oracle' CPU cycles per second

The translation of this formula is:

The cost is the time spent on single block reads, plus the time spent on multiblock reads, plus the CPU time required, all divided by the time is takes to do a single block read.

This means that the cost of a query is the PREDICTED EXECUTION TIME, counted innumber of single block read timesand is effectively the unit of measure of the cost.


consultium
consultium 		Latest page update: made by consultium , Oct 7 2009, 4:16 PM EDT (about this update About This Update consultium Edited by consultium

72 words added

view changes
- complete history)
Keyword tags: CBO COST FORMULA REF REFERENCE
More Info: links to this page

Threads for this page

There are no threads for this page.  Be the first to start a new thread.

Related Content

  (what's this?Related ContentThanks to keyword tags, links to related pages and threads are added to the bottom of your pages. Up to 15 links are shown, determined by matching tags and by how recently the content was updated; keeping the most current at the top. Share your feedback on Wetpaint Central.)
Analytical Functions (1) Index Of Oracle SQL Commands AUTOTRACE options and examples
Standard Utility scripts Login Script Raw Trace Data Stat meanings
Structure of an Extended SQL Trace file Effective MULTIBLOCK READ COUNT values used in cost calculations HOW TO trace the CBO working out the execution path (event 10053)
Creating Reports