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.
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
Oracle E-Business Suite of Applications
•The Big Picture – The EBS Release 12.1.3 Upgrade NEW! – Mike Swing, TruTek
•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
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.
Loading ...