AppsDBA.com Publications

The following are technical papers and presentations that detail information or tasks that can be used to support an Oracle Applications environment.

Technical Papers

Oracle Workload Characterization Presentation - Presented at the 2007 Hotsos Symposium

Oracle Workload Characterization Presentation - Presented at the November 2006 Northern California Oracle Users Group meeting.

Oracle Workload Characterization - A new paper exploring how to characterize Oracle workload. This paper is a follow on to the "Oracle Workload Measurement" and is the next step in the workload management process.

Concurrent Manager Queue Overlap Analysis Presentation - Presented at the 2006 Oracle Open World conference.

Concurrent Manager Queue Overlap Analysis - A new paper describing how to manage Oracle Applications concurrent manager queue workload through a new technique called Queue Overlap Analysis.

Oracle Workload Measurement - A paper that describes Oracle workload measurement. This paper was presented at the Hotsos 2005 Symposium and the May 2005 Northern California Oracle Users Group meeting.

Oracle Workload Management Using Time Based Optimization Techniques 

Oracle 9.2 Event 10046 Segment-level Statistics

Creating A System Identifier For Oracle Applications Systems

Please note that there was an error in both of the documents below!  I mistakenly referred to FNDMDCMF instead of FNDMDGEN to generate the message file on the forms server.   Sorry for the inconvenience.

NCA System Identification (Displaying database name) - As featured in the January 2000 issue of the OAUG Insight.

Oracle Applications Environment Management White Paper

Other Papers

ADPATCH Basics -  An excellent paper on patching by Sean Tuck.  This paper was handed out by Oracle Support at the 2000 Philadelphia OAUG Conference.

Release 11 Cloning -  A summary put together by Brian Meyette paper on cloning a Release 11 system.  Brian put this out to the oaugnet-dba list and we offered to host it here for him.

OAUG Papers/Presentations

OAUG Fall 2002 DB SIG Presentation: Finding Apps Users

OAUG Fall 2001 Training Session: Getting All The Pieces: Reliable Backup/Recovery (Power Point Show - 138K zipfile or PDF format - 3909K)

OAUG Spring 2000 Backup and Recovery Panel: Oracle8i Duplicate Database Feature  

OAUG Fall 1999 DB SIG Presentation: Restoring To A Different Location With EBU And RMAN

OAUG Fall 1999 DB SIG Presentation: Oracle Applications Database Copy Procedures

OAUG Spring 1999 paper, Sizing Oracle Applications Projects, A Technical Perspective

OAUG Fall 1995 paper, ORACLE7 I/O Monitoring - the original Workload paper.