2 blogs on Oracle Optimization
Wednesday Dec 12, 2007
Two blogs on Oracle Optimization that are worth a look:
http://optimizermagic.blogspot.com/
Two blogs on Oracle Optimization that are worth a look:
http://optimizermagic.blogspot.com/
IBM is now directly targeting Oracle, see the IBM Redbook "Oracle to DB2 Conversion Guide - Converting to DB2 for Linux, UNIX, and Windows" http://www.redbooks.ibm.com/Redbooks.nsf/RedpieceAbstracts/sg247048.html?Open
Oracle seems to have updated their pricing (amazing what you can find when one forages around on google in this case "multicore pricing Oracle faq"). This all seems to have happened a couple of weeks ago, according the the dates on the documents, but I guess I missed it in other blogs or articles.
Full price list is at: http://www.oracle.com/corporate/pricing/pricelists.html
To help understand it on the left there is an FAQ, or if you want to see it directly: http://www.oracle.com/corporate/pricing/multicore_faq.pdf
Interesting preso on Linux, showing Windows beating it in performance. details at: www.oracle.com/technology/tech/dotnet/col/europe2006/ukoug_2006-best_practices_rac_on_64-bit_windows.ppt
"Load Test Windows 2003 v Red Hat 4.0 (64 bit)"
...here are my summary from their slides:
"RAC Stress Test (150-250 users)
RAC User Load Tests (2500–4500 users)
Sun-PostgreSQL win shows benefit of Solaris over Linux. Pretty interesting trends happening in open-source databases.
You can read more at: http://www.computerworld.com.au/index.php/id;413111662
This also shows why you can't just look at over-optimized benchmarks link TPC-C, one needs to look at real factors in the datacenter. For TPC-C issues you see previous posts:
http://blogs.sun.com/bmseer/entry/judging_by_the_wrong_things
...and also some questionable(?) changes over time:
http://blogs.sun.com/bmseer/entry/ibm_tpc_c_more_hints