Friday, November 04, 2005
Oracle Essays
Recently I recommended "Oracle Insights," a book containing a series of Oracle-related essays by some of the top authors in our community. For those who are interested in reading some more essays, consider some of the following samples from a variety of my favourite authors on a variety of topics. The best part is that these are free!
Re-building Indexes: When, How, Why by Jonathan Lewis
http://www.jlcomp.demon.co.uk/indexes.doc
Programming Humility: Dealing with the Reality of Errors by Steven Feuerstein of Quest Software
http://www.odtug.com/Handouts_05/Feuerstein.zip
Locking and Concurrency by Tom Kyte
http://www.dbazine.com/oracle/or-articles/kyte1/
Practical Guide to Oracle Data Warehousing by David Aldridge
http://databasejournal.com/features/oracle/article.php/3098791
Query Tuning Using DBMS_STATS by Dave Ensor
http://www.dbazine.com/oracle/or-articles/ensor6
String Aggregation Techniques by Dr. Tim Hall
http://www.oracle-base.com/articles/10g/StringAggregationTechniques.php
Bind Variables Explained by Mark Rittman
http://www.rittman.net/archives/000832.html
The following two articles are also worth mentioning again.
Why a 99%+ Database Buffer Cache Hit Ratio is Not Ok, by Cary Millsap of Hotsos
http://www.oradream.com/pdf/Why%20a%2099%20Cahe%20Hit%20Ratio%20is%20Not%20OK.pdf
Why I Invented YAPP by Anjo Kolk (Free registration for download)
http://www.oraperf.com/logon.html?rpage=download.php/yapp_anjo_kolk.pdf
While recommending some reading, I'm also including my favourite Oracle community debates of 2005:
The great Burleson/Kyte debate on "Predictive Reorganization"
http://asktom.oracle.com/pls/ask/f?p=4950:8:8515227363337669542::NO::F4950_P8_
DISPLAYID,F4950_P8_CRITERIA:35336203098853
The great Dizwell Forum debate: "Natural vs Surrogate keys"
http://www.phpbbserver.com/phpbb/viewtopic.php?t=189&mforum=dizwellforum&sid=135
The great Burleson/Lewis debate on "Supersizing your PGA"
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:47466211228419
Re-building Indexes: When, How, Why by Jonathan Lewis
http://www.jlcomp.demon.co.uk/indexes.doc
Programming Humility: Dealing with the Reality of Errors by Steven Feuerstein of Quest Software
http://www.odtug.com/Handouts_05/Feuerstein.zip
Locking and Concurrency by Tom Kyte
http://www.dbazine.com/oracle/or-articles/kyte1/
Practical Guide to Oracle Data Warehousing by David Aldridge
http://databasejournal.com/features/oracle/article.php/3098791
Query Tuning Using DBMS_STATS by Dave Ensor
http://www.dbazine.com/oracle/or-articles/ensor6
String Aggregation Techniques by Dr. Tim Hall
http://www.oracle-base.com/articles/10g/StringAggregationTechniques.php
Bind Variables Explained by Mark Rittman
http://www.rittman.net/archives/000832.html
The following two articles are also worth mentioning again.
Why a 99%+ Database Buffer Cache Hit Ratio is Not Ok, by Cary Millsap of Hotsos
http://www.oradream.com/pdf/Why%20a%2099%20Cahe%20Hit%20Ratio%20is%20Not%20OK.pdf
Why I Invented YAPP by Anjo Kolk (Free registration for download)
http://www.oraperf.com/logon.html?rpage=download.php/yapp_anjo_kolk.pdf
While recommending some reading, I'm also including my favourite Oracle community debates of 2005:
The great Burleson/Kyte debate on "Predictive Reorganization"
http://asktom.oracle.com/pls/ask/f?p=4950:8:8515227363337669542::NO::F4950_P8_
DISPLAYID,F4950_P8_CRITERIA:35336203098853
The great Dizwell Forum debate: "Natural vs Surrogate keys"
http://www.phpbbserver.com/phpbb/viewtopic.php?t=189&mforum=dizwellforum&sid=135
The great Burleson/Lewis debate on "Supersizing your PGA"
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:47466211228419
