Skip to Main Content
Optimizing Oracle Performance
book

Optimizing Oracle Performance

by Cary Millsap, Jeff Holt
September 2003
Intermediate to advanced content levelIntermediate to advanced
416 pages
14h 1m
English
O'Reilly Media, Inc.
Content preview from Optimizing Oracle Performance

Index

A note on the digital index

A link in an index entry is displayed as the section title in which that entry appears. Because some sections have multiple index markers, it is not unusual for an entry to have several links to the same section. Clicking on any link will take you directly to the place in the text in which the marker appears.

A

Adams, Steve, Responding to the Diagnosis
ALTER SESSION SET EVENTS command, Time Scope Errors at Trace Activation
Amdahl’s Law, Amdahl’s Law, Glossary
analyzing response time, Tools for Analyzing Response TimeResource Profile
resource profiles, Resource ProfileResource Profile
sequence diagrams, Sequence DiagramSequence Diagram
application identification, SQL trace data files, Application identification
applications
client-server, finding trace files for, Simple Client-Server Applications
connection-pooling, finding trace files for, Connection-Pooling ApplicationsSome Good News
packaged software, convincing vendors to improve performance of, Eliminating Wasteful Work
scalable, attributes of, Attributes of a Scalable Application
architecture, multitier application, Parse Optimization

B

BACKGROUND_DUMP_DEST parameter, Finding Your Trace File(s)
directory, Trace Writing
MTS and, Oracle Multi-Threaded Server
bind variables
avoiding hard parses with, Parse Optimization
SQL trace data files, Bind variables
buffer busy wait events, “Too Much Data” Is Really Not Enough Data, Logical I/O Optimization

C

cache hit ratio (see CHR)
capacity upgrades, Upgrade Capacity
case studies, ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Database 11gR2 Performance Tuning Cookbook

Oracle Database 11gR2 Performance Tuning Cookbook

Ciro Fiorillo

Publisher Resources

ISBN: 059600527XSupplemental ContentErrata Page