Papers and Presentations

Check out these papers, written by our favorite Oracle experts in the business. Don't forget to check out our Books section - these papers are often just the beginning of a writer's best work.


Oracle E-Business Suite of Applications

The Big Picture - The Release 12.2.4 Upgrade - Mike Swing, TruTek

The Big Picture - The Release 12.1.3 Upgrade Review - Mike Swing, TruTek
Release 12.1.3 Technical Upgrade Overview - Mike Swing, TruTek
What You Need to Know About Identifying Customizations Before Upgrading to Release 12.1 - Donna Campbell and Barb Matthews
Clean Up That Mess! A Mother's Guide to Managing Your E-Business Suite Clutter NEW! - Barb Matthews
Lessons From the Front: Upgrading to Release 12.1 - Barb Matthews
Six Easy Pieces: Essentials of Database Tuning for Packaged Applications - Mike Swing, TruTek
Parallel Concurrent Processing Failover and Load Balancing of E-Business Suite Release 11i and Release 12 - Mike Swing, TruTek.
Managing Performance in Oracle Applications Release 11 using STATSPACK - Mary Crystal, Echostar Communications Corporation, Tim Gorman, SageLogix Inc.
Fueling the Workflow Engine - Writing Custom PL/SQL to be Called from your Workflow Processes - Dan Stober, Intermountain Healthcare
Customization Survival Guide: How to Use E-Business Utilities to Migrate Your Custom Code - Brad Simmons and Donna Campbell
Migrating 11i to RAC with DataPump - Mike Swing, TruTek; Fred Linnenbrink, Metro St. Louis
A Quick Look At Oracle's New User Management Security Wizards (UMX) in Release 12 - Ervin McFadden
Migrate Your Customizations with iSetup Part I - Barbara Matthews, OnCallDBA

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
Oracle New Features (8i, 9i, 10g) - Robert Freeman, LDS ChurchOracle 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

PeopleSoft

Obtaining and Interpreting Execution Plans Using DBMS_XPLAN - David Kurtz, Go-Faster Consultancy Ltd.
An Introduction to (BEA) Tuxedo - David Kurtz, Go-Faster Consultancy Ltd.
Practical Guidance on the Use of PeopleSoft Performance Monitor - David Kurtz, Go-Faster Consultancy Ltd.
PeopleTools 8.48/8.49 New Database Features - David Kurtz, Go-Faster Consultancy Ltd.
PeopleSoft: A Properly Instrumented Application - David Kurtz, Go-Faster Consultancy, Ltd.

Oracle Database Security

Unraveling the Sweater: Oracle Database Security (1) - Tim Gorman, Evergreen Database Technologies, Inc.
Unraveling the Sweater: Oracle Database Security (2) - Tim Gorman, Evergreen Database Technologies, Inc.

Oracle E-Business Suite R12.2 Upgrade Training & R12.2 Consulting