Oracle 9i/10g OLAP Mailing List

Monday, May 24th, 2004 by Mark Rittman

If anyone’s interested, Peter Odds and I have set up an Oracle OLAP mailing list as an additional resource for developers working with the OLAP Option. The list homepage is at http://www.rittman.net/lists/olap where you can subscribe, change subscription options or view the list archives. With a bit of luck it’ll be an additional way for [...]

mySQL As A Data Warehousing Platform?

Monday, May 24th, 2004 by Mark Rittman

Julian Ford passed on a link to an article by Michael J. Radwin on Buildng Data Warehouses With mySQL. The article refers to a presentation by John Ashenfelter who’s also written a book on mySQL and data warehousing which is due out in July 2004. Data warehousing using mySQL on one hand sounds counter-intuitive but [...]

A Guide To The Performance Tuning Enhancents In Oracle 10g

Thursday, May 20th, 2004 by Mark Rittman

There’s a good article currently running over at Oracle-base.com detailing the performance tuning enhancements in Oracle Database 10g. It’s a fairly detailed document and covers the following areas; Automatic Performance Diagnostic and Tuning Features Automatic Shared Memory Management Wait Model Improvements Automatic Optimizer Statistics Collection Dynamic Sampling CPU Costing Optimizer Hints Rule Based Optimizer Obsolescence [...]

Howard Fosdick’s “DBA Certification Secrets: How to Pass the Tests”

Thursday, May 20th, 2004 by Mark Rittman

"Our previous article in this series,

Guide To Installing Oracle 10g On Debian

Monday, May 17th, 2004 by Mark Rittman

Andy Todd points out a useful guide to installing Oracle Database 10g on Debian. According to the guide, "We go through, step-by-step, the process of installing Oracle 10g Release 1 (10.1.0.2) Enterprise/Standard Edition for Linux x86 on a Debian unstable installation as of 2004-04-01. This chapter was originally written by Damien McAullay with suggestions from [...]

Website Design & Build: tymedia.co.uk