The Oracle
Magician
The latest tricks
from Oracle Ace, Chris Lawson 
Now Available on Amazon!
Snappy
Interviews: 100 Questions to Ask Oracle DBAs
See sample chapters: The Art & Science of Oracle
Performance Tuning
how to
give a bad presentation! (ppt) New!
ten
performance lessons (ppt) New!
Why
is Flashback Query Slow? (pdf) New!
Ten Surprising Performance Tactics (pdf)
Ten Surprising
Performance Tactics (power point)
Extreme Performance Tuning
(NoCoug Presentation)
Oracle RAC: Finding the
Resource Master
Oracle Performance Tuning
on RAC versus Single-Node : What’s the Difference?
Overview of GoldenGate
Replication by Brian Keating
How to use RAC Parallel
Instance Groups
Automatic SGA
Resizing--Watch Out!
RAC Performance Tuning: Is
RAC Like "Bolt-on Power?"
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 "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
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
Database Trends and
Applications
- Prototype Strategy for Data Warehouse
IOUG-A Select
Magazine
- Setting up Veritas Cluster Server (VCS)
- Enterprise Backup Utility (EBU)
- Performance Tuning with Oracle Enterprise Manager
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
Power Point Presentations for NoCOUG
- Ten Database Mysteries
- Ten More Database Mysteries
- Setting up Oracle Hot Standby Database
- Escape from the Data Warehouse Death March
Other White Papers
Inquiries re
Consulting Availability: Chris@OracleMagician.com
Soli Deo Gloria