Optimizer cost as a function of tablespace block size

From: Ranko Mosic <ranko.mosic_at_gmail.com>
Date: Sat, 25 Feb 2006 16:54:31 -0500
Message-ID: <367369f10602251354h28b3b6b3s5c697d25166d07a8@mail.gmail.com>

Hi List,
Reading Jonathan's book on optimizer. Trying to confirm his results, but no dice in this case ( and I know he is usually right ) on page 21, script tablescan_04.sql
His query cost is going down with bigger tablespace block size. My results are opposite for noworkload system statistics - query cost is going up with bigger ts block size.
I am on 10.2; he tested on 10.1 but it shouldn't make the difference.

Any ideas ?

--

Regards,
Ranko Mosic
Contract Senior Oracle DBA
B. Eng, Oracle 10g, 9i Certified Database Professional Phone: 416-450-2785
email: mosicr_at_rogers.com
http://ca.geocities.com/mosicr@rogers.com/ContractSeniorOracleDBARankoMosicMain.html

--

http://www.freelists.org/webpage/oracle-l Received on Sat Feb 25 2006 - 15:54:31 CST