Skip to content

Oracle Performance Tuning Database Management Systems

Best in textbook rentals since 2012!

ISBN-10: 1565922379

ISBN-13: 9781565922372

Edition: 2nd 1996

Authors: Mark Gurry, Peter Corrigan, Debby Russell

List price: $79.99
Shipping box This item qualifies for FREE shipping.
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!


The books in O'Reilly's Oracle series are authoritative -- they tell the whole story about complex topics, ranging from performance tuning to the use of packages in PL/SQL to new technologies like Power Objects. And they're independent; they're alternatives for readers who need to know how products and features really work. They're packed with real-world advice and techniques from practitioners in the field, and they come with disks containing code you can use immediately in your own applications. O'Reilly is the alternative for Oracle people who need to solve problems -- and solve them now. Performance tuning is crucial in any modern relational database management system. Too many…    
Customers also bought

Book details

List price: $79.99
Edition: 2nd
Copyright year: 1996
Publisher: O'Reilly Media, Incorporated
Publication date: 12/10/1996
Binding: Paperback
Pages: 964
Size: 7.00" wide x 9.19" long x 2.35" tall
Weight: 2.970

As a database administrator on a financial IMS project about eight years ago, Mark Gurry was asked to investigate his company's database direction for the next five years. The number of users was up to 950, the cost of maintaining the mainframes was huge, and he'd heard about relational databases and downsizing. After much investigation, he chose Oracle, and has stuck with the system ever since. He has worked as Manager of Computing and Network Services, senior database administrator, senior Oracle technical support, and other jobs. He now has a small consulting company called New Age Consultants. Mark has worked for many large organizations and is currently working for Telecom Australia,…    

Peter Corrigan lectures in the Department of Sociology at the University of New England, Australia

I: Overview
Introduction to Oracle Performance Tuning Why Tuning?
Who Tunes?
When Do You Tune?
A Look at Recent Versions How Much Tuning Is Enough?
What Causes Performance Problems?
Problems with Design and Development
Problems with System Resources Memory
Problems and Tuning Disk I/O
Problems and Tuning CPU
Problems and Tuning Network
Problems and Tuning
II: Tuning for Managers and Planners
Planning and Managing the Tuning
Process Managing the Problem of Response
Time Managing the Problem of Long-Running
Jobs Managing the Workload in Your System Making the Decision to Buy More Equipment
Management Checkpoints Performance Hints for Managers
Defining System Standards Selecting a Common
Design Methodology
Selecting Your Software
Selecting Your Hardware
Setting Up Screen and Report
Templates Using Modular Programming Techniques
Defining System Libraries Enforcing
Program Version Control
Establishing Documentation Standards
Establishing Database Environment Standards
Security Standards
Performance Standards
III: Tuning for Designers and Analysts
Designing for Performance
Common Design Problems
Choosing an Architecture
Tuning Your Data Model
Tuning Indexes
Testing the Data Model for Performance
Denormalizing a Database
Constraints Triggers Packages, Procedures, and Functions
Designing a Very Large Database
Application Miscellaneous
Design Considerations
IV: Tuning for Programmers
Tuning SQL
SQL Standards
Optimizer SQL
Tuning Common Sense in SQL
SQL Performance
Tips and Hints Using
Indexes to Improve Performance
SQL Tuning Alternatives
Identifying Poor SQL Statements
Adjusting SQL Statements Over Time
Tuning PL/SQL
What Does PL/SQL Offer?
PL/SQL Limitations
PL/SQL Coding Standards
Tuning PL/SQL
Exploiting the Power of PL/SQL
Oracle PL/SQL Function Extensions
Selecting a Locking Strategy What Is Locking?
Releasing Locks Avoiding the Dreaded Deadlock Locking
Considerations for Oracle Features
Overriding the Default Locking Strategy
Internal Lock Contention Lock Detection Scripts
V: Tuning for Database Administrators
Tuning a New Database Steps in Setting Up a Database
Tuning Memory
Tuning Disk I/O
Creating the Database
Creating the Tablespaces
Creating Rollback Segments
Creating Tables
Creating Indexes
Creating Views
Creating Users INIT.ORA Parameter Summary
Creating Very Large Databases
Diagnostic and Tuning Tools Monitor
Monitoring System Activity Tables SQL_Trace
Writing a Trace File TKPROF
Interpreting the Trace File Explain Plan
Explaining the Optimizer''s Plan ORADBX
Listing Events Analyze
Validating and Computing Statistics UTLBSTAT.sql and UTLESTAT.sql
Taking Snapshots Other Oracle Scripts Some Scripts of Our