White Papers

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, send it to us for inclusion on this page.

Index

• Oracle Server/ DBA
• Oracle Web/ Application Server and Portal
• Oracle Programmer
• Oracle Developer
• Oracle Designer
• Oracle ERP Applications
• Oracle Warehousing, OLAP and Express
• Other pages with Oracle papers
• Browser plugin's needed to view papers

Oracle Server/ DBA Papers

• Tuning ASM [PDF, 138K]

• Disassembling the Oracle Data Block [PDF, 334K]

• Estimate the size of B-tree Indexes [PDF, 960K]

• The Oracle REDO Generation [PDF, 723K]

• Why Have Scattered Thoughts About Oracle Reads? [PDF, 302K]

• How to Create a Non-Managed Standby Database [PDF, 26.8K]

• Features comparison between MSSQL 2005 and Oracle 10g [PDF, 245.7K]

• Reading and Storing Data Directly From Oracle SGA using Pro*C/C code [PDF, 78.2K]

• DBMS_SYSTEM - "missing" section from the PL/SQL supplied packages manual [Word, 128K]

• ORADEBUG - Undocumented Oracle Utility [PDF, 149300 bytes]

• New Features of RMAN [PDF, 18476 bytes]

• Oracle DBA Checklist [DOC, 45K]

• MRPP - Microstate Response-time Performance Profiling [PDF, 786223 bytes]

• Oracle9i on IBM ESS F20 - Redo Logs and ESS RAID5 volumes: To log or not to log? [PDF, 353K]

• The Oracle Calendar [Word, 27136 bytes]

• Test Database Generation and Management [PDF, 40260 bytes]

• Hunting Down CPU related issues with Oracle: A functional Approach [PDF, 378182 bytes]

• Oracle LOBs - what, why and how [Word, 80384 bytes]

• The Importance of ECommerce, DSS and OLTP End-user Service Level Analysis [Word, 27136 bytes]

• DBA Testimonial: Why DBA's job skip [Word, 22528 bytes]

• Disassembling the Oracle Redolog

• A comparative analysis between SQL Loader and UTL_FILE [Word, 89088 bytes]

• Performance Tuning - Now You are the V8 Expert [Word, 161280 bytes]

• Space & Structure Management Presentation [PowerPoint, 74720 bytes]

• Rollback Segments Presentation [PowerPoint, 91648 bytes]

• Constraints on Updateable Snapshots with Oracle8 Replication [Word, 25600 bytes]

• Riddles of Read-Only Tablespaces [Word, 27136 bytes]

• Tuning SQL*Net by minimizing data transmissions [Word, 33792 bytes]

• Create an Oracle8i Database in Windows [PDF, 25727 bytes]

• Oracle8i Backup and Recovery: Planning Metrcs and Rules of Thumb [PDF, 353K]

• Database Administration Maturity Model [PDF, 71K]

• Low Administration Oracle Speciication (LAOS) - Part 1: Avoiding Administration [PDF, 37K]

• The Three Schema Security Model [DOC, 23K]

• Oracle 7.3 Data Dictionary on a single page [PDF, 45254 bytes]

Oracle Web/ Application Server and Portal Papers

• 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 [PDF, 33Kb]

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 [Word, 22016 bytes]

Oracle Designer Papers

• Generating a WebForm using Designer 6 : less than an hour [Word, 565760 bytes]

• How to capture the design of a non-Oracle database using Designer 6 [Word, 187392 bytes]

• Twenty Steps to Prototyping with Designer/2000 [Word, 16896 bytes]

• 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

• How to send log or output files as an attached mail [PDF, 100K]

• Using Oracle Workflow with Ebusiness Suite [PDF, 714K]

• Oracle Financials Archive and Purge [PDF, 50K]

• Oracle Applications 11i10 - Forms Personalization [PDF, 418.2K]

• Enhance your project documentation process with Oracle Applications Implementation Methodology (AIM) [PDF, 91.7K]

Oracle Warehousing, OLAP and Express Papers

• Data Sanitization Techniques [PDF, 25k]

Other pages with Oracle Papers

• All the Oracle OpenWorld Technical Papers are available on-line. Check them out!

• Herv Deschamps' Oracle Papers

• OraPub of Earth - Read/ submit Oracle related white papers

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)