Home | Consulting | Resume | Whitepapers | Scripts | Sandbox
Contact Info  
  Whitepapers: Oracle Performance
A Quick Note
Many of these papers are for earlier versions of Oracle but many of the concepts still hold true, especially with respects to performance issues.

If you're looking to really brush up on your Oracle performance skills take a few minutes to checkout Craig Shallahamer's OraPub site.

I've chatted with Craig several times over the years and he's a great guy. He was one of the early Oracle performance guru's. He left Oracle after many years to form his own consulting company.


  • Total Performance Management
  • Predicting Computing System Capacity & Throughput
  • Oracle7 Space Management
  • Designing Your Systems To Meet Your Needs
  • Optimal Flexible Architecture
  • Avoiding A Database Reorganization
  • Oracle7 Sizing & Capacity Planning Guide For VAX OpenVMS Systems
  • Configuring The Oracle Server For VLDB
  • Database Management From Crisis To Confidence
  • Oracle Test-To-Scale Program: Data Warehousing
  • Overview of Oracle SystemSizer for Compaq Systems

  • Oracle For UNIX: Performance Tuning Tips
  • Oracle For Sun: Performance Tuning Tips
  • Microsoft Windows NT Server 4.0 versus UNIX
  • Netware Performance Tuning
  • What are the tunable kernel parameters for Solaris 2?
  • Tuning The Performance of the Oracle7 Parallel Query Option
  • Optimizing OCI Applications For Client/Server Environments
  • Tuning The Oracle7 Database For Optimum Performance
  • Configuration & Tuning of Oracle7 for Novell UnixWare 2.0 On Compaq Servers
  • Oracle7 Workgroup Server for Intel UNIX Performance Tuning
  • V$SESSION / V$SYSSTAT Statistics
  • Instance Performance Ratios via SNMP
  • Discrete Transactions
  • Miscellaneous Tuning Rules
  • V$LIBRARYCACHE Statistics
  • Various INIT.ORA Parameters
  • Acquiring Baseline Information

  • Tuning The Oracle Server - Identifying Internal Contention
  • Identifying Resource Intensive SQL During Production

  • Tuning Developer/2000 Application Performance on the Web

  • Oracle Raw Partitions
  • RAID: What does it mean to me?
  • RAID levels zero through five
  • Oracle7 Symmetrical Replication
  • Oracle7 Symmetrical Replication: Strategies & Techniques
  • Oracle7 Release 7.3
  • Oracle7 Release 7.3 + New Features
  • An Introduction To Designer/2000 For DBAs
  • Oracle For Sun - An Enterprise Computing Platform
  • Oracle For Sun: Guide To Tools & Services For Rightsizing
  • TPC Benchmarks March 1996
  • The Oracle WebServer: A Technical Discussion
  • How to Build Web Applications Using Oracle7 and Oracle WebServer
  • Oracle WebServer 2.0 Overview

  • Block Clean Out  An interesting read
  • © Copyright 1998 - 2009 Allen Hayden. All rights reserved.