To access the contents, click the chapter and section titles.

High-Performance Oracle Database Applications
(Imprint: Coriolis)
(Publisher: The Coriolis Group)
Author: Donald K. Burleson
ISBN: 1576101002

Introduction
Dedication

CHAPTER 1—Logical Performance Design For Oracle Databases
Performance And Database Distribution
The Economics Of Database Design
Location Transparency And Database Design
Distributed Database Performance And Tuning Methods
An Example Of A Distributed Database Design
Using Referential Integrity
Database Design For Performance
Normalization And Modeling Theory
Misleading Data Relationships
Denormalizing Many-To-Many Data Relationships
Dealing With Recursive Data Relationships
STAR Schema Design
Summary

CHAPTER 2—Physical Performance Design For Oracle Databases
Indexes
Constraints And Indexes
Using Multi-Column Indexes
How Oracle Chooses Indexes
Allocating Oracle Tables
Referential Integrity And Performance
Oracle Stored Procedures
Pinning Oracle Packages In The SGA
Oracle Triggers
Deciding When To Use A Trigger
Oracle Hash Tables
Oracle Clusters
Oracle Parallel Query
Towards Oracle8
Oracle Sedona
Oracle ConText
Oracle Express
The Object Layer
SQL For Object-Orientation
Summary

CHAPTER 3—Tuning The Oracle Architecture
The Oracle Architecture
Oracle’s Internal Structures
Oracle Metadata—The V$ Tables
Tuning Oracle Memory
Sizing The SGA
Using The db_block_size Parameter With db_file_multiblock_read_count
Tuning Oracle Sorting
The Oracle PGA
Tuning The shared_pool_size
Tuning The Dictionary Cache
Multithreaded Server Tuning
Tuning The db_block_buffers Parameter
Predicting The Benefit Of Additional Block Buffers
Memory Cache Tuning
Simulating The Pinning Of Database Rows
Interoperability Facilities
Creating Batch-Oriented Oracle Instances
I/O-Based Tuning
Disk Striping
Tuning Data Fragmentation
Disk Issues With Other System Resources
Summary

CHAPTER 4—Tuning Oracle SQL
Tuning Oracle SQL Syntax
General Tips For Efficient SQL
Tuning SQL With Indexes
Concatenated Indexes
Using Oracle’s Explain Plan Facility
Using Temporary Tables
Tuning With The Rule-Based Optimizer
Using Hints With The Cost-Based Optimizer
Tuning PL/SQL
Using Oracle Stored Procedures And Triggers
Simulating Object-Orientation
Inheritance
Abstraction
Pointer-Based Navigation
Invoking Methods In SQL
Using ODBC As A Server Interface
Summary

CHAPTER 5—Tuning Oracle Locking
The Problem Of Cohesive Updating
Dirty Reads
Nonreproducible Results
Database Corruption (Bad Foreign Keys)
Database Locking And Granularity
Oracle Locking
Database Deadlocks
Escalation Of Locks With Non-Oracle Servers
Alternative Locking Mechanisms For Oracle
The WHERE Clause
Locking And Distributed Databases
Understanding The Two-Phase Commit
Measuring Oracle Locks
Identifying Conflicts
Using catblock.sql And utllockt.sql
Summary

CHAPTER 6—Oracle DBA Performance And Tuning
Using The Unrecoverable Option
Using Read-Only Tablespaces
Determining Where To Place Indexes
Bitmapped Indexes
Summary

CHAPTER 7—Performance And Tuning For Distributed Oracle Databases
Replication With Oracle Snapshots
How Oracle Snapshots Work
Asynchronous Updating Of Oracle Tables
Parallelism And Client/Server
Multitasking And Multithreading
SMP Vs. MPP Processing
Using Oracle’s Parallel Query
Planning For Growth
Block Sizing
Tablespace Considerations
Tablespace Fragmentation
Tablespace Reorganization
Table Fragmentation
Row Fragmentation
Designing Expert Systems For Performance Measurement
Disk Issues With Distributed Database Performance
Platform Computing’s Load Sharing Facility
Heterogeneity
Summary

CHAPTER 8—Performance And Tuning For Oracle Database Connectivity Tools
Database APIs
The Internals Of ODBC
Programming For Portability
Intersystem Connectivity
The Internals Of Oracle’s SQL*Net
Application Connection With SQL*Net
SQL*Net For Client/Server
Understanding The SQL*Net Listener
Managing SQL*Net Connections
Managing Two-Phase Commits (2PCs)
Establishing SQL*Net Sessions
Cross Database Connectivity With IBM Mainframes
Summary

CHAPTER 9—Linking Oracle And Non-Oracle Databases
The History And Evolution Of Linking Multivendor Databases
The Gateway Products
Data Replication Products
Middleware Solutions
Remote Measurement
Summary

CHAPTER 10—Tuning Oracle Data Warehouse And OLAP Applications
Data Warehousing And Multidimensional Databases
Expert Systems
Decision Support Systems And Data Warehouses
Data Warehouses
Data Aggregation And Drill-Down
Relational Answers To MDDB
Populating STAR Schemas With Distributed SQL
Aggregation, Roll-Ups, And STAR Schemas
History Of OLAP
Alternatives To Cubic Data Representation
Data Mining And OLAP
An Illustration Of STAR Schema Design
Using Oracle 7.3’s Features With Data Warehouses
Parallel Query For Data Warehouses
STAR Query Hints And STAR Joins With Oracle 7.3
Using Oracle’s Bitmap Indexes
Using Oracle 7.3 Hash-Joins
Summary

CHAPTER 11—Oracle Application Monitoring
Proactive Vs. Reactive Measuring Techniques
Creating An Oracle-Based Monitor
Gathering The Oracle Performance Statistics
Creating A Performance Repository With Oracle Utilities
Using Oracle utlbstat And Outlets Utilities
What Oracle Statistics Do We Want To Collect?
Building The Oracle Performance Database
Local Oracle Processing
cron Run Schedules
Performance Reports
Online Menu For The Performance System
Running The Oracle Reports And Alerts
A Closer Look—BMC’s Patrol
Patrol’s Knowledge Module
Patrol Reports
Patrol Exception Handling
Summary

CHAPTER 12—The Future Of Database Management—Object Technology
The Benefits Of Object Management
The Object Management Architecture Components
The OMG Object Model
The Object Management Architecture
Object Request Broker
Summary
Appendix A
Appendix B
Index