Whitepapers

Whitepaper Topics
Oracle Database Performance Tuning
Oracle Database Server

Performance Tuning Whitepapers

Insights on how to gather and manage Oracle optimizer statistics to maintain a stable and highly performing oracle environment.

Presentation slides (as presented at Rocky Mountain Oracle Users Group Training Days February 2006).

Success and failure factors for data warehouses built using Oracle, and a roadmap for success starting with partitioning and dimensional data models. (As presented at the Rocky Mountain Oracle Users Group Training Days 2005 and 2006).

An important piece of data warehouse infrastructure that is usually overlooked: SQL statement usage tracking. (As presented at the Oracle Users Group conferences and IOUG-A "Live 99" April 1999 Denver, CO).

SageLogix's Methodology on IO performance tuning.

Make the cost-based optimizer (CBO) come alive and start working. The CBO has had a checkered past, but with enhancements in Oracle8 and Oracle8i, it is finally time to put the venerable old rule-based optimizer (RBO) to bed for good. (Written for the Rocky Mountain Oracle Users Group newsletter, and recently presented at the Utah Oracle Users Group DBA SIG 27-July 2001).

Oracle's R11 release of Financials and Order Entry applications, Oracle's new standard STATSPACK, its design, configuration, installation, and a customized tuning solution for this complex scenario. (As presented at the Rocky Mountain Oracle Users Group Training Days 2002, the Twin Cities Oracle Users Group 18-July 2002).

A methodology for determining where SQL tuning problems are located and a description of the tools that can be used to fix them. (As presented at the Rocky Mountain Oracle Users Group Training Days 1996, numerous Oracle Users Group conferences, Oracle OpenWorld Australasia 1997).

Although space management is an old topic that has been thoroughly covered by excellent papers by Cary Millsap and Craig Shallahamer, I felt it was necessary to cover this ground one more time, to debunk some of the most persistent myths in the world of Oracle technology. (Appeared in the "Winter 2001 issue of SQL Update", the newsletter of the Rocky Mountain Oracle Users Group).

A clear understanding of the causes of the dreaded ORA-01555 error message (i.e. "snapshot too old") and what can (and cannot) be done to minimize or prevent it.

Three important features of Oracle8 Recovery Manager that absolutely no other backup/recovery solution is capable of matching, and why these features might be crucial to help fulfill your requirements and expectations. (As presented at the Eastern Caribbean Oracle Users Group Trinidad 14-March-2001, and at the Rocky Mountain Oracle Users Group Denver Training Days 2000 10-February-2000).

Database Server Whitepapers

Sort out the differences between using Storage Area Networks and Network Attached Storage in an Oracle envrionment.

Oracle’s implementation of indexes works very well and is quite clever, improving on the basic designs set down decades ago. There seems to be an impression that they don’t work very well or they need constant maintenance, and that is just not true.