Rittman Mead - Delivered Intelligence

This
isn’t one I’ve come across before.

"Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning"
by Kirtikumar Deshpande and K. Gopalakrishnan is

described by Amazon as "Troubleshoot, tune, and optimize your Oracle
database efficiently and successfully every time. This book explains how to take
full advantage of the revolutionary Oracle Wait Interface to quickly
pinpoint–and solve–core problems and bottlenecks, […]

Installation
Guide: Oracle Database 10g on Linux x86: "This is the first in a
series of guides that provide all the steps for installing the major components
of Oracle 10g software on Linux. All three of the certified
English-language distributions of Linux are covered in detail (Asianux is not
covered), and the articles assume that inexpensive Intel x86 hardware is […]

Pete Finnigan, famous for his
excellent Oracle security white
papers and alerts, has
started a new
Oracle security weblog.
So far there’s been some useful and interesting postings on
truncating
the audit trail,
the SANS
S.C.O.R.E. Oracle security checklist being updated and
Arup Nanda’s
article on the new "Oracle security patch nightmare". Pete’s also made an
RSS feed available which you can subscribe to
here.

Back in July I wrote an article about
Oracle Information
Architecture, Oracle’s new BI-centric vision of an integrated organisation
that brings together new products and technologies such as Applications 11i,
Customer Data Hub, Grid Computing and Service-Orientated Architecture.
If this is of interest to you, Oracle now have a set of Information
Architecture pages on the corporate website, including an
overview […]

A good discussion on comp.databases.oracle.server on the

real-world value of the new features in Oracle 9i and 10g, including
interesting comments on

comparing 10g and SQL Server 2000,

how useful the new 10g features actually are, and the

potential achilles heel for Oracle that is tuning via the wait interface.

I came across another interesting blog the other day.
The ETL Guy has only a few postings so far but
looks promising, with amongst others some interesting articles on
Modelling Objects in a Relational DBMS,
Hardware Sizing,
Normalize for accuracy, denormalize for
performance and Stupid ETL Mistake #2:
Saving Disk Space.

Dispelling Oracle myths seems to be a regular theme at the moment, and
Steven Feuerstein dispels a few PL/SQL coding myths
himself in a new article for Oracle Magazine called

"Controlling Mythological Code". According to Steven,

"Don’t use the XYZ feature; there was a problem back in version n.n."
"Always use explicit cursors; doing so is the […]

I came across this interesting presentation by Rachel Carmichael given at a
recent New York Oracle User Group, entitled
"How Not To Be A DBA - The
Top Twenty Mistakes". It’s a light-hearted look at what *not* to do when
you’re a DBA, including:

"Don’t Backup If You’re On RAID5",
"Index Every Column On Every Table",
"Always Increase The Shared Pool […]

If you’re in the UK and Ireland and interested in Oracle tuning, you’ll be
interested to know that Cary Millsap and Gary Goodman are presenting at the

next UKOUG UNIX SIG meeting on the 28th September. Their presentation is
entitled
"Profiling Oracle, How it Works" and has the following synopsis.

"Conventional Oracle "tuning" methods are outrageously complex, and they
[…]