Oracle performance tuning / Mark Gurry & Peter Gorrigan.

Format:

Book

Author/Creator:

Gurry, Mark.

Contributor:

Corrigan, Peter.

Series:

Nutshell handbook

Nutshell handbook Oracle performance tuning

Language:

English

Subjects (All):

Relational databases.

Database management.

SQL (Computer program language).

Oracle (Computer file).

Physical Description:

1 online resource (966 p.)

Edition:

2nd ed.

Place of Publication:

Cambridge, Massachusetts : O'Reilly & Associates, 1996.

Language Note:

English

Summary:

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

Contents:

Table of Contents; Why Tuning? 5; Who Tunes? 8; When Do You Tune? 9; A Look at Recent Versions 17; How Much Tuning Is Enough? 24; Problems with Design and Development 27; Problems with System Resources 30; Memory Problems and Tuning 33; Disk I/O Problems and Tuning 35; CPU Problems and Tuning 38; Network Problems and Tuning 40; Managing the Problem of Response Time 44; Managing the Problem of Long-Running Jobs 49; Managing the Workload in Your System 53; Making the Decision to Buy More Equipment 55; Management Checkpoints 57; Performance Hints for Managers 61

Selecting a Common Design Methodology 64Selecting Your Software 64; Selecting Your Hardware 65; Setting Up Screen and Report Templates 68; Using Modular Programming Techniques 71; Defining System Libraries 71; Enforcing Program Version Control 73; Establishing Documentation Standards 73; Establishing Database Environment Standards 74; Security Standards 76; Performance Standards 77; Common Design Problems 83; Choosing an Architecture 85; Tuning Your Data Model 88; Tuning Indexes 98; Testing the Data Model for Performance 103; Denormalizing a Database 106; Constraints 117; Triggers 119

Packages, Procedures, and Functions 121Designing a Very Large Database Application 121; Miscellaneous Design Considerations 130; SQL Standards 134; The SQL Optimizer 138; SQL Tuning 148; Common Sense in SQL 163; SQL Performance Tips and Hints 173; Using Indexes to Improve Performance 183; SQL Tuning Alternatives 191; Identifying Poor SQL Statements 201; Adjusting SQL Statements Over Time 203; PL/SQL and SQL 206; What Does PL/SQL Offer? 206; PL/SQL Limitations 213; PL/SQL Coding Standards 218; Tuning PL/SQL 221; Exploiting the Power of PL/SQL 242; Oracle PL/SQL Function Extensions 260

What Is Locking? 269Releasing Locks 272; Avoiding the Dreaded Deadlock 274; Locking Considerations for Oracle Features 276; Overriding the Default Locking Strategy 284; Internal Lock Contention 289; Lock Detection Scripts 292; Steps in Setting Up a Database 301; Tuning Memory 302; Tuning Disk I/O 309; Creating the Database 317; Creating the Tablespaces 320; Creating Rollback Segments 337; Creating Tables 344; Creating Indexes 351; Creating Views 356; Creating Users 357; INIT.ORA Parameter Summary 358; Creating Very Large Databases 379; MONITOR: Monitoring System Activity Tables 387

SQL_TRACE: Writing a Trace File 388TKPROF: Interpreting the Trace File 391; EXPLAIN PLAN: Explaining the Optimizer's Plan 397; ORADBX: Listing Events 406; ANALYZE: Validating and Computing Statistics 408; UTLBSTAT.sql and UTLESTAT.sql: Taking Snapshots 410; Other Oracle Scripts 424; Some Scripts of Our Own 427; Oracle Performance Manager 442; Identifying Untuned Application Code 444; Tuning Memory 453; Tuning Disk I/O 479; Avoiding Contention 497; Introduction to Parallel Server 521; Parallel Server Architecture 523; Parallel Server Locking 525; Parallel Server Design 529

Parallel Server Database 537

Notes:

"Database management systems"--Cover.

Corrigan's name appears first on the earlier edition.

Includes index.

Description based on print version record.

ISBN:

9780596515676

0596515677

9781565929166

1565929160

OCLC:

775301469