The Oracle
Magician
The latest tricks
from Chris Lawson 
as
of June 21, 2012
Now Available on Amazon!
Snappy
Interviews: 100 Questions to Ask Oracle DBAs
See sample chapters: The Art & Science of Oracle
Performance Tuning
Ten Surprising Performance Tactics (pdf) New!
Ten Surprising Performance Tactics (power point) New!
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