Papers and Presentations

Check out these papers, written by our favorite Oracle experts in the business. If you'd like to submit a paper for inclusion on our site, send a note to sherri@trutek.com. And don't forget to check out our Books section - these papers are often just the beginning of a writer's best work.

Performance Tuning

• Understanding Indexes - Tim Gorman, Evergreen Database Technologies, Inc.
• In Defense of Full-Table Scans - Jeff Maresh, Maresh Consulting, Inc.
• Myths about Extents and Performance - Tim Gorman, Evergreen Database Technologies, Inc.
• Performance Problems Related to the Reparsing of SQL Statements - Jeff Maresh, Engineering Solutions
• The Search For Intelligent Life in the Cost-Based Optimizer - Tim Gorman, Evergreen Database Technologies, Inc.
• Tuning Sort and Hash Memory Areas - Jeff Maresh, Maresh Consulting, Inc.
• Managing Performance in Oracle Applications Release 11 using STATSPACK - Mary Crystal, Echostar Communications Corporation, Tim Gorman, Evergreen Database Technologies, Inc.
• Supercharging Star Transformations - Jeff Maresh, Maresh Consulting, Inc.
• Scaling to Infinity: Partitioning in Oracle Data Warehouses - Tim Gorman, Evergreen Database Technologies, Inc.
• Performance Diagnostics using STATSPACK data - Tim Gorman, Evergreen Database Technologies, Inc.
• Index Organized Tables: When Should They be Used? - Alon Peled
• Investigating the Multiple Buffer Pool Feature of Oracle8 - John Beresniewicz, Savant Corporation
• Microstate Response-Time Performance Profiling - Danisment Gazi Unal
• An Introduction to SQL Trace, TKPROF and Execution Plans - David Kurtz, Go-Faster Consultancy Ltd.
• Getting Started Optimizing Oracle Performance - Craig A. Shallahamer, OraPub, Inc.
• Getting Started with Forecasting Oracle Performance - Craig Shallahamer, OraPub, Inc.

Oracle Database

• Never a DUL Moment: How to Avoid Costly Data Recovery - Daniel Fink, OptimalDBA
• Using a Disciplined Approach to Problem Diagnosis - Daniel Fink, OptimalDBA
• TOAD Tips and Techniques - Dan Hotka
• Why is My Oracle10g Database Slower Than My Oracle9i Database? - Dan Hotka
• Getting the Most Out of AWR -Tim Gorman, Evergreen Database Technologies, Inc.
• Oracle Database 11g New Features - Robert Freeman, LDS Church
• Analytical Functions and Regular Expressions in SQL - Daniel Fink, OptimalDBA
• Advanced Oracle Troubleshooting - Tanel Poder
• Latch, Lock and Mutex Contention Troubleshooting - Tanel Poder
• Oracle SQL Plan Execution: How it Really Works - Tanel Poder
• Oracle New Features (8i, 9i, 10g) - Robert Freeman, LDS Church
• Using RMAN for Backup and Recovery - Robert Freeman, LDS Church
• Automatic Undo Internals - Daniel W. Fink, OptimalDBA
• Cats, Dogs, and ORA-01555 - Tim Gorman, Evergreen Database Technologies, Inc.
• The Utility of Logon Triggers - Jeff Maresh, Maresh Consulting, Inc.
• Managing the Data Lifecycle - Jeff Maresh, Maresh Consulting, Inc.
• Materialized Views in Action - Jeff Maresh, Maresh Consulting, Inc.
• ORADEBUG-Undocumented Oracle Utilility - Miladin Modrakovic
• Raid: High Performance, Reliable Secondary Storage - Peter M. Chen, Edward K. Lee, Garth A. Gibson, Randy H. Katz, David A. Patterson
• Is RMAN Really Worth the Trouble? - Tim Gorman, Evergreen Database Technologies, Inc.
• MAID for ILM Archival Storage for Data Warehouses - Information Lifecycle Management - Tim Gorman, Evergreen Database Technologies, Inc.
• All About Oracle's In-Memory Undo - Craig Shallahamer, OraPub, Inc.

Oracle Developer

• Coding Therapy for Developers- Steven Feuerstein
• Automated Testing Options for PL/SQL - Steven Feuerstein
• Why You Should Care About Oracle 11 g - Right Now! - Steven Feuerstein