Oracle performance tuning
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 ne...
| Autor principal: | |
|---|---|
| Otros Autores: | |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Cambridge, Massachusetts :
O'Reilly & Associates
1996.
|
| Edición: | 2nd ed |
| Colección: | Nutshell handbook
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009649835306719 |
Tabla de Contenidos:
- 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
