Design & Capacity Planning

• Sense and Scalability
• Scalable I/O, Part 1
• Scalable I/O, Part 2
• Designing Very Large Databases for High Availability: Making it Easy
• It's Time to Think About Archiving
• Fine-grained Space Management in Oracle
• Make Way for the Petabytes!
• Cookbook for Sizing Objects
• Total Performance Management (PDF)
• Predicting Computing System Capacity & Throughput (PDF)
• Oracle7 Space Management (PDF)
• The OFA Standard: Oracle7 for Open Systems (PDF)
• Avoiding A Database Reorganization (PDF)
• Oracle7 Sizing & Capacity Planning Guide For VAX OpenVMS Systems (PDF)
• Configuring The Oracle Server For VLDB (PDF)
• Database Management From Crisis To Confidence (PDF)
• Oracle Test-To-Scale Program: Data Warehousing (PDF)
• Overview of Oracle SystemSizer for Compaq Systems (PDF)

Performance Tuning

• Performance and Tuning Considerations for Running Oracle Databases on EMC Storage (PDF)
• Oracle Parallel Server with EMC Symmetrix (PDF)
• Tuning and Managing A Large SAP System (PDF)
• High Speed Replication for Oracle (PDF)
• Managing Multi-Table Joins (PDF)
• Explain Plan: Everything You Wanted To Know And Had No-One To Ask (PDF)
• Oracle Block Size - Larger is Better (PDF)
• The "How to" for bstat/estat report (Word)
• Tuning Packaged Software and Production Applications (PDF)
• Tuning the Application-Centric Data Warehouse
• Performance Monitoring's Cutting Edge
• Oracle Performance Strategies
• Interpreting And Applying Explain Plan Results (Word)
• Getting the Most from the SQL_TRACE Facility
• Do It Yourself: Implement Performance Monitoring Tool
• WAIT is a 4-Letter Word
• Tuning SQL Statements that use the IN Operator
• Partitioning Applications to Take Advantage of Oracle's Parallel Server
• Accelerating Indexed Searching
• Tuning Packaged Software and Production Applications
• Tuning Application Logic
• A DBA's Guide to Optimizing Oracle Sorts
• Application Tuning, Part 1
• Application Tuning, Part 2
• Application Tuning, Part 3
• Oracle Undocumented Parameters
• Description of Oracle7 Wait Events and Enqueues (PDF)
• Bitmapped Indexes (PDF)
• Tuning Large Sorts (PDF)
• Use the Stats in the Report Generated by the UTLBSTAT and UTLESTAT
• A Guide to Oracle Performance Tuning, Part 1
• A Guide to Oracle Performance Tuning, Part 2
• Five Performance Hints for Efficient SQL
• Oracle For UNIX: Performance Tuning Tips (PDF)
• Oracle For Sun: Performance Tuning Tips (PDF)
• What are the tunable kernel parameters for Solaris 2?
• Optimizing OCI Applications For Client/Server Environments (PDF)
• Tuning The Oracle7 Database For Optimum Performance
• Configuration & Tuning of Oracle7 for Novell UnixWare 2.0 On Compaq Servers (PDF)
• 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 (PDF)
• Identifying Resource Intensive SQL During Production (PDF)

Data Warehouse

• Scrub a Dub Dub! Data Warehouse Transformation Rules
• The Exploration Warehouse
• Data Warehousing in the Insurance Industry: The Insurance Data Warehouse, Part 1
• Data Warehousing in the Insurance Industry: Mining the Insurance Data Warehouse, Part 2
• Data Warehousing in the Insurance Industry: Designing High-Performance DSS Databases, Part 3
• Data Warehouse Meta Data -- What's That?
• Data Mart Does Not Equal Data Warehouse
• Incremental Data Warehouse Updates
• Building Effective Data Marts
• Building the Right Data Mart
• Big Warehouse, Big Decisions
• Bringing up Supermarts

Ralph Kimball Articles

• Helper tables let you design and manage multivalued dimensions successfully (08/98)
• Defining what a data warehouse manager should (and shouldn't) do (07/98)
• Pipelining Your Surrogates (06/98)
• Surrogate Keys (05/98)
• Is Data Staging Relational? (04/98)
• Meta Meta Data Data (03/98)
• Human Resources Data Marts (02/98)
• The Operational Data Warehouse (01/98)
• Relocating the ODS (12/97)
• Preparing For Data Mining (11/97)
• Digging Into Data Mining (10/97)
• Turbocharge Your Query Tools (09/97)
• Data Warehouse Role Models (08/97)
• It's Time for Time (07/97)
• What Does the Central Team Do? (06/97)
• Traveling through Databases (05/97)
• Hackers, Crackers, and Spooks (Security) (04/97)
• Caught in the Internet Whirlpool (Query Tools) (03/97)
• Features for Query Tools (02/97)
• Letting The Users Sleep, Part 2 (01/97)
• Letting The Users Sleep, Part 1 (12/96)
• Causal (Not Casual) Dimensions (11/96)
• It's Time for Data Compression (10/96)
• Factless Fact Tables (09/96)
• Dangerous Preconceptions (08/96)
• Automating Data Extraction (07/96)
• Mastering Data Extraction (06/96)
• Monster Dimensions (05/96)
• Slowly Changing Dimensions (04/96)
• Drilling Down, Up, and Across (03/96)
• SQL Roadblocks and Pitfalls (02/96)
• The Problem with Comparisons (01/96)
• Data Warehouse Insurance (12/95)
• The Aggregate Navigator (11/95)
• Is ER Modeling Hazardous to DSS? (10/95)
• The Database Market Splits (09/95)

RAID & Raw Partition

• A description of RAID and what the RAID levels stand for
• Oracle Raw Partitions
• RAID: What does it mean to me?
• RAID levels zero through five

Symmetrical Replication

• Replication, Replication, Replication
• Oracle7 Symmetrical Replication (PDF)
• Oracle7 Symmetrical Replication: Strategies & Techniques (PDF)

PL/SQL

• Truly Translating Booleans, Part 1
• Truly Translating Booleans, Part 2
• 10 PL/SQL Tips: Simplifying a Complex Language
• Tuning Oracle PL/SQL
• Using Oracle Pipes to Perform Unix Commands
• Cursors, Confused Again! Who Does What When?
• Implementing DECODE for PL/SQL
• Climbing the Spiral to PL/SQL Excellence, Part 1
• Climbing the Spiral to PL/SQL Excellence, Part 2
• Teaching and its Rewards (PL/SQL)

ORACLE WebServer

• JDBC and Firewalls
• Data Binding in Dynamic HTML
• Building Your First WebServer Application: A Tutorial
• Oracle WebServer
• Oracle WebServer FAQ
• Oracle Web Server 101: Introduction to Oracle WebServer and the PL/SQL Agent
• The Oracle WebServer: A Technical Discussion
• How to Build Web Applications Using Oracle7 and Oracle WebServer
• Oracle WebServer 2.0 Overview

Oracle 7

• Optimizing Oracle 7.3 Database Performance (PDF)
• Space Management in Oracle7
• Description of Oracle7 Wait Events and Enqueues (PDF)
• Tuning The Performance of the Oracle7 Parallel Query Option (PDF)
• Tuning the Oracle7 Database for Optimal Performance
• Tuning Large Sorts (PDF)
• Oracle7 Workgroup Server for Intel UNIX Performance Tuning
• Oracle7 Release 7.3
• Oracle7 Release 7.3 + New Features

Oracle 8

• Taking Advantage of Partitioning in Oracle8
• Star Queries in Oracle8
• Oracle8 for Data Warehousing - Overview
• Overview of New Backup and Recovery Capabilities for Oracle8
• Oracle8 Enterprise Edition Release 8.0: Overview
• Inside Oracle8
• The Oracle8 Warehouse
• Migrating to Oracle8: QuickStart on New Features
• Using the Oracle8 RowID Format
• Managing Unstructured Data with Oracle8
• Extending Oracle8 with Objects
• Oracle8 Objects Option
• Inside Oracle8
• Reading the Mind of Oracle 8
• Will Oracle8 Be Universal?
• Oracle8 VLDB Enhancement

Oracle on NT

• Oracle8 on Windows NT Data Sheet
• The Oracle DBA's Guide to NT
• Running on NT

Miscellaneous Stuff

• Tools for the Trade
• Solving Oracle Data-Block Corruption
• A Day in the Life of an Enterprise DBA
• How to Create a Good Test Database
• Java in a N-Tiered Oracle Environment
• Setting Some Difficult INIT.ORA Parameters
• Getting Physical with Oracle
• DBA Scripts
• Migrating Applications Between Oracle Databases
• Object Relational Reality Check
• Sizing Up Parallel Architectures
• Oracle's Parallel Offerings
• Go Beyond the Data Dictionary - Utilize the V$ Tables
• More Undocumented Features Oracle Job Queue Facility
• More 'Features', Utilities and Tips Select Star
• Integrating with ORACLE Enterprise Manager
• Database Security Makes Good Business
• Converting Legacy Data to Oracle
• DBA of the Future
• Change Maxdatafiles/Logfiles & Creating Controlfile
• Object / Relational Grows Up
• A Scout's Guide to Three-Tier Architecture
• Bringing Object Relational Down To Earth
• Block Clean Out
• Oracle Bulletins: Exporting, Backing Up, Recovery, Moving, etc.
• Library Cache & Shared Pool Tuning (PDF)
• Explanation of the ORA-4091 "Table is mutating..." error
• FAQ Listing of the 100 Most Common Questions About the export/import Utility (PDF)
• Backing up the Oracle Enterprise
• Understanding Oracle Backup Techniques
• Parallel Processing for Decision Support
• Building on Bigger Boxes
• Oracle Year 2000 Pitfalls
• Designer/2000 Administration: Tuning Tips and Techniques
• An Introduction To Designer/2000 For DBAs (PDF)
• Oracle For Sun - An Enterprise Computing Platform (PDF)
• Oracle For Sun: Guide To Tools & Services For Right Sizing (PDF)
• TPC Benchmarks March 1996 (PDF)

Power Point Presentations

• Oracle7 Release 7.3: Enterprise Data Management
• Oracle8 (Short)
• Oracle8 (Long / Technical)

10 Scripts Every DBA Should Have by Kevin Loney

1. Display the Current Archivelog Status
2. Creating a Control File Trace File
3. Tablespace Free Extents and Free Space
4. Display Allocated Space and Quota by User
5. Show Allocated Storage for All Objects
6. Map a Tablespace's Used and Free Space
7. Blocks Used by Data in a Table
8. Reset a User's Password
9. Query V$PARAMETER
10. Show Statement Execution Path

Magazines (Internet)

• DBMS Magazine
• Database Program & Design
• Data Management Review
• Oracle Magazine
• Oracle Review
• Data-Warehouse.com
• UNIX Review & Performance Computing

Links (Internet)

• Oracle Corporation
• Oracle Technical Review
• Oracle Trial Software
• International Oracle Users Group
• Oracle Developer Programme
• Oracle Related Whitepapers
• Oracle Underground FAQ
• TUSC - IOUG Docs & Presentations
• RevealNet - Tip of the Month
• Oramag - Tip of the Week
• Ken Atkins' - Tip of the Week
• Peter Koletzke's Oracle Utilities
• Oracle FAQ: Free Software
• The Data Warehousing Information Center (White Papers)
• O'Reilly.com (Oracle Books)
• Amazon.com (Oracle Books)
• Bookpool (Oracle Books)
• Oracle Press: Source Code Library
• Oracle Resources (Jobs, Resumes & Links)

Some of these files (PDF) require Adobe's Acrobat Reader