Rittman Mead - Delivered Intelligence

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

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

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

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

"Our
previous article in this series,

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"

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