Dan Hotka On Tuning SQL Statements

Tuesday, May 25th, 2004 by Mark Rittman

"Tuning problematic SQL statements is neither rocket science nor magic.
All relational databases generate an execution plan for the submitted SQL. This
execution plan then tells Oracle how to retrieve the data, or, how to perform
the data-related tasks. The better you understand how to interpret these explain
plans, the better you can resolve possible performance issues with the […]

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 9i/10g OLAP Option developers
to share ideas, […]

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 also
has a few things going […]

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
[…]

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 Giuseppe Sacco"

Claudia Imhoff On BI Technology Standards

Wednesday, May 5th, 2004 by Mark Rittman

"JOLAP, XML/A, JDBC, OLE- DB, ODBC, MDAPI, DCOM, CORBA, J2EE, and
even dear old MOM is in there somewhere. It sounds like alphabet soup or the
refrain of "Old McDonald Had a Farm" (E-I-E-I-O…) in terms of the
jumble of acronyms that represent the plethora of standards our industry
creates. Standards are a good thing. They make life easier […]