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. 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
- Release 12.1.3 Technical Upgrade Overview NEW! - Mike Swing, TruTek
- The Big Picture - The Release 12.1.3 Upgrade Review NEW! - Mike Swing, TruTek
- What You Need to Know About Identifying Customizations Before Upgrading to Release 12.1 NEW! - 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 NEW! - Barb Matthews
- Six Easy Pieces: Essentials of Database Tuning for Packaged Applications NEW! - Mike Swing, TruTek
- Oracle Applications 11.5.10 Tips, Tricks, and Features - Jeff Mick, Midmark
- Parallel Concurrent Processing Failover and Load Balancing of E-Business Suite Release 11i and Release 12 - Mike Swing, TruTek
- News from the Trenches - An E-Business Suite R12 11g Implementation - Jerry Ireland, Mark W. Farnham, Rightsizing, Inc.
- 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
PeopleSoft
Oracle Database Security
|