Cargando…
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 need t...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Otros Autores: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Sebastopol :
O'Reilly Media, Inc.,
2007.
|
| Edición: | 2nd ed. |
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
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? 119Packages, Procedures, and Functions? 121; Designing 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? 260What Is Locking?? 269; Releasing 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? 387SQL_TRACE: Writing a Trace File? 388; TKPROF: 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.