Oracle Performance Tuning

The Oracle

Magician

The latest tricks from Chris Lawson

as of Feb 2, 2008

Now Available on Amazon!
Snappy Interviews: 100 Questions to Ask Oracle DBAs

snappy

snappy

just_cover

See sample chapters: The Art & Science of Oracle Performance Tuning

Get details on this book

RAC Performance Tuning: Is RAC Like "Bolt-on Power?" Now Available!

Analyzing RAC Performance using AWR Reports Coming Soon!

Performance Tuning--A Matter of Life & Death?

SHA-1 Data Encryption for Oracle 9i

Professional Networking for IT Consultants

Oracle Streams Performance

Oracle Streams white paper by Brian Keating In-Depth Analysis!   Streams Spot Check

Oracle Streams Powerpoint (Brian Keating/Chris Lawson)

Introduction to Oracle Spatial by Richard Flores

Different Ways to Find Unused Indexes

Why doesn't the Index Order Matter?

Is my System Really Available 24x7?

Calculate Range Partitions using Ntile

Performance Tips for Batch Jobs

The Mystery of "Null" Wait Events

Writing a Book about Oracle: Art or Science ?

A Puzzle: When are Nested-Loop Joins Free?

Visit the Oracle Magician Bookshop!
Technical, Management, and Finance/Investing books at discount prices!

Get the latest version of The Oracle Magician Magazine

April 2007 Issue: .pdf format New! "When is a table Hot?"
Sept 2006 Issue: .pdf format "Is there a Flowchart to Success?"
Mar 2006 Issue: .pdf format "Solve Performance Problems with more Joins!"
Oct 2005 Issue: .pdf format "Multithreading & Oracle Parallelism"
April 2005 Issue: .pdf format
Jan 2005 Issue: .pdf format
Nov 2004 Issue: .pdf format "When to use Not Exists" & "Multiblock Reads"
Sept 2004 Issue: .pdf format
July 2004 Issue: .pdf format
Mar 2004 Issue: .pdf format
July 2003 Issue: .doc format
Nov 2002 Issue: .doc format .pdf format
May 2002 Issue: .doc format .pdf format
Jan 2002 Issue: .doc format .pdf format

Intelligent Enterprise, February 21, 2002

The Power of Prototyping (case study of DigitalThink's data warehouse)

"IOUG-A LIVE" 2002 and Oracle OpenWorld 2002

Chris Lawson & Roger Schrag:
Don’t Shut Down That Database! Use Oracle 9i Online Object Redefinition Instead!

White Paper Power point Presentation

Chris Lawson: Don’t Settle for Mere Competence - Be the Magician!

White Paper Power point Presentation

Prepared for High Technology Careers

Learning on the Job

Database Trends and Applications

Prototype Strategy for Data Warehouse

IOUG-A Select Magazine

Northern Calif Oracle User’s Group (NOCOUG) Journal

Exploring Oracle (requires subscription)

Make Oracle Available 24x7 with Veritas Cluster Server
Materialized View and Query Rewrite
Composite Partitioning, Part I and II

Oracle Internals (requires subscription)

Exploring Oracle 9i Online Reorganizations
Star versus Star Transformation
Exploring Oracle LogMiner
Performance Tuning using Oracle's Database Resource Manager

Oracle Informant

Using Oracle Names

Power Point Presentations for NoCOUG

Other White Papers

Inquiries re Consulting Availability: Chris@OracleMagician.com

Soli Deo Gloria