Papers

Below are some free Oracle White Papers you can download:

You can have your papers, reports and presentations published here. Whenever you write an article for a user's group, or a good report to your boss, upload it and include it on this page (free papers only).

Oracle Server/ DBA papers

• Implementing Oracle 10g on Windows, Part 1: Optimizing Memory Usage
• Let UNIX Drive Your Oracle Interfaces
• Oracle's Approach to Performance Tuning Part I
• Oracle's Approach to Performance Tuning Part II
• Oracle Trace Analyzer - A New Tuning Tool
• Simplify Your Life with Oracle SQL*Loader
• Subgrid Load Balancing for Utility Computing
• Survey of Oracle Recovery Options
• An Overview of Oracle Support for the Linux Operating System
• Generating High-Quality Test Data with Oracle SQL*Loader
• Subgrid Load Balancing for Utility Computing
• Tuning ASM
• Disassembling the Oracle Data Block
• Estimate the size of B-tree Indexes
• The Oracle REDO Generation
• Why Have Scattered Thoughts About Oracle Reads?
• How to Create a Non-Managed Standby Database
• Features comparison between MSSQL 2005 and Oracle 10g
• Reading and Storing Data Directly From Oracle SGA using Pro*C/C code
• DBMS_SYSTEM - "missing" section from the PL/SQL supplied packages manual
• ORADEBUG - Undocumented Oracle Utility
• New Features of RMAN
• Oracle DBA Checklist
• MRPP - Microstate Response-time Performance Profiling
• Oracle9i on IBM ESS F20 - Redo Logs and ESS RAID5 volumes: To log or not to log?
• The Oracle Calendar
• Test Database Generation and Management
• Hunting Down CPU related issues with Oracle: A functional Approach
• Oracle LOBs - what, why and how
• The Importance of ECommerce, DSS and OLTP End-user Service Level Analysis
• DBA Testimonial: Why DBA's job skip
• Disassembling the Oracle Redolog
• A comparative analysis between SQL Loader and UTL_FILE
• Performance Tuning - Now You are the V8 Expert
• Space & Structure Management Presentation
• Rollback Segments Presentation
• Constraints on Updateable Snapshots with Oracle8 Replication
• Riddles of Read-Only Tablespaces
• Tuning SQL*Net by minimizing data transmissions
• Create an Oracle8i Database in Windows
• Oracle8i Backup and Recovery: Planning Metrcs and Rules of Thumb
• Database Administration Maturity Model
• Low Administration Oracle Speciication (LAOS) - Part 1: Avoiding Administration
• The Three Schema Security Model
• Oracle 7.3 Data Dictionary on a single page

Oracle Web/ Application Server and Portal Papers

• A Portal into Oracle Portal - Oracle Portal can serve as a bridge between your users, your company, and the Internet
• Creating a Hierarchical List of Value component in Portal for folders
• Web Application Performance: Black Magic Tuning Prohibited

Oracle Programmer papers

• Optimistic Locking with Concurrency in Oracle
• Lower Your Consulting Costs - Host Your Own Oracle JAD Session

Oracle Developer papers

• Shortcut for Oracle Developer Runtime deployment
• Supercharge your PL/SQL Development with the right Tools
• D2K interview questions
• Everything You Ever Wanted To Know About Oracle Reports 2.5
• ROWNUMbering with an ORDER BY clause
• Using Oracle's DBMS_APPLICATION_INFO built-in package.

Oracle Designer papers

• Generating a WebForm using Designer 6 : less than an hour
• How to capture the design of a non-Oracle database using Designer 6
• Twenty Steps to Prototyping with Designer/2000
• Web Generate Record Cloning with Designer - Part 1
• Web Generate Record Cloning with Designer - Part 2
• Web Generate Mass Updates with Designer
• Web Generate Auto-Refresh Pages with Designer
• Designer 2.1.2: Web Generate those Titles
• Web Generate Powerful Navigation with Designer 2.1.2
• Designer/2000 2.1.2. API: Enforcing Column Naming Standards
• Designer/2000 2.1.2. QC API: List attributes with no maximum length specification
• Designer/2000 2.1.2. API: Fast Display Setting for Columns with Allowable Values
• Designer/2000 API: Providing View Column Display Properties
• Generating 100% drilling with Designer/2000
• Ordering by Lookup DCU using Designer/2000
• Designer/2000 API: Jump Start a new application in Designer 2000
• Designer/2000 QA: Better than a matrix: Function Entity Usages Exceptions
• Designer/2000 QA: Ghost Relationships
• Designer/2000 API: Replacing CHAR with VARCHAR2
• Designer/2000 API: Creating First Cut Domains for all Attributes
• Designer/2000 API: Retrofitting DCU Display Properties

Oracle ERP Applications papers

• Building Reports Using Oracle's Flexfield Support API
• Real Time Migration of Oracle Application Setups Done In House
• Migrating from SQL Server 2000 to Oracle 9i
• Oracle 11i Receivables Implementation Primer
• Oracle 11i Shipping Execution – Interface Trip Stop Trouble Shooting
• Oracle Application Database Management Part I - Take Database Monitoring in Oracle Applications Manager to the Next Level
• Oracle Application Database Management Part II - Navigating Oracle Applications Manager
• Oracle Key Flexfields – Security, Tips, and Tricks
• Battling Growth and Staying Compliant Through Oracle Application Archiving
• Oracle Development - Part 1: Are Your Customizations Protected?
• Oracle Development - Part II: Coding Guidelines for Customizations
• Oracle Development - Part III: Coding Standards
• Instance Cloning Under Your Control: Taking the Mystery Out of Replicating 11i Instances
• Overcoming Barriers to Supplier Collaboration
• Maintaining "Unique Customer Profile" for Oracle CRM Implementations
• Discoverer Portlets for Sharing 11i Order Management Data with Customers
• Oracle HRMS Position Control – Do You Really Have Control?
• Instance Cloning Under Your Control: Taking the Mystery Out of Replicating 11i Instances
• Batch Invoice Uploads into Oracle Payables Using MS Excel
• 11i Inventory’s Cost Cutoff Date – Defer Costing Until Your Standard Costs Have Been Updated!
• Where Is Oracle Time and Labor Headed?
• Why Oracle iProcurement
• Work Order-less Completion as an Alternative to Outside Processing
• How to send log or output files as an attached mail
• Using Oracle Workflow with Ebusiness Suite
• Oracle Financials Archive and Purge
• Oracle Applications 11i10 - Forms Personalization
• Enhance your project documentation process with Oracle Applications Implementation Methodology (AIM)
• Learn about exposing Pl/Sql as REST Web Service in R12.2.4
• Oracle Toolkit to Fix Your Automotive EDI Needs
• Extending Oracle EBusiness Suite with Mobility Solutions
• Use of OEDQ in Conversion Process
• Multi Year Contracts with Budgetary Control

Oracle Warehousing and Discoverer papers

• Data Sanitization Techniques
• Oracle Discoverer 10g Interfaces
• Oracle Discoverer 10g – Is It More Than a Simple Reporting Tool

Other papers

• Ten Ways to Know When Your Oracle Project has Taken Over Your Life (Humor)
• It Takes All Kinds (Humor)
• Decisions Decisions - Five Things CIO's Often Forget
• The Life of an Email
• TOAD Tips and Techniques
• Use Your Creativity
• Do You Have an Affirmative Action Plan
• How Much Is That Oracle Database in the Window
• Oracle's Presence in the Embedded Systems Software Market: An Overview
• Data Masking: What You Need To Know

Credits

This site obtained the right to publish and distribute all papers listed here. Please consult each paper for details about the copyright holder.

Many of the above papers were donated by the former OraTips.com.

Other sites with Oracle papers

• Herv Deschamps' Oracle Papers
• OraPub of Earth - Read/submit Oracle related white papers
• oraclewhitepapers.com

Browser plugin's needed to view papers

• Download Adobe Acrobat Reader (free of charge).
• Get the MS-Word Plugin from Microsoft (free of charge)
• Open Office (read MS-Word documents on Windows or Linux)