Home » RDBMS Server » Performance Tuning » PLan Cost?-Sql Tuning
PLan Cost?-Sql Tuning [message #245865] Tue, 19 June 2007 01:53 Go to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
Hi

Can u plz tell how the oracle calculate the plan cost

regards

Tarun Mittal
Re: PLan Cost?-Sql Tuning [message #245898 is a reply to message #245865] Tue, 19 June 2007 03:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
With many and many diferent algorithms.
Read Jonathan Lewis' book: http://www.amazon.com/Cost-Based-Oracle-Fundamentals-Jonathan-Lewis/dp/1590596366/ref=sr_1_1/102-9990061-0843323?ie=UTF8&s=books& amp;qid=1182241940&sr=1-1

Regards
Michel
Re: PLan Cost?-Sql Tuning [message #246121 is a reply to message #245898] Wed, 20 June 2007 01:03 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
How we recognised that a query is optimize or not if we have two execution plan of a particular query

Plan 1

Plan Cost 5801 Executin Time 00:00:05:965 TOTAL CPU 17.92 Physical Read 106375 Logical Read 106547 Scan Row 3 Scan Gets 3 Rowid gets 439138


Plan 2

Plan Cost 16020 Executin Time 00:00:02:775 TOTAL CPU 8.83 Physical Read 118226 Logical Read 118446 Scan Row 6071072 Scan Gets 228414 Rowid gets 0

so if we compare both the plan we found plan 2 execution time is less but plan cost is too high.

so i m confuse. How to compare execution plan's

Kindly confirm

It's urgent

it's on production

Regards

Tarun MIttal
Re: PLan Cost?-Sql Tuning [message #246122 is a reply to message #246121] Wed, 20 June 2007 01:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
It's urgent

it's on production


Call a SQL expert.
Do you want J. Lewis email address?

Regards
Michel

[Updated on: Wed, 20 June 2007 01:05]

Report message to a moderator

Re: PLan Cost?-Sql Tuning [message #246126 is a reply to message #245898] Wed, 20 June 2007 01:11 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
I m using oracle 9i release 2 base version on windows 2000
Re: PLan Cost?-Sql Tuning [message #246135 is a reply to message #246122] Wed, 20 June 2007 01:37 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
Plz give me

Thanks
Re: PLan Cost?-Sql Tuning [message #246141 is a reply to message #246135] Wed, 20 June 2007 01:52 Go to previous message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
jonathan@jlcomp.demon.co.uk

Regards
Michel
Previous Topic: Rebuild index online
Next Topic: Want to use Alias
Goto Forum:
  


Current Time: Wed Dec 07 07:02:56 CST 2016

Total time taken to generate the page: 0.21698 seconds