| Description |
1 online resource (964 pages) |
| 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? 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. |
| Note |
Parallel Server Locking? 525. |
| 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 solve th. |
| Subject |
Oracle (Computer file)
|
|
Oracle (Computer file) |
|
Relational databases.
|
|
Database management.
|
|
SQL (Computer program language)
|
|
Database management. |
|
Oracle (Computer file) |
|
Relational databases. |
|
SQL (Computer program language) |
|
Computer science. |
|
Bases de données relationnelles. |
|
Bases de données -- Gestion. |
|
SQL (Langage de programmation) |
|
Database management |
|
Relational databases |
|
SQL (Computer program language) |
| Added Author |
Corrigan, Peter.
|
| Other Form: |
Print version: Gurry, Mark. Oracle Performance Tuning. Sebastopol : O'Reilly Media, Inc., ©2007 9781565922372 |
| ISBN |
9780596515676 |
|
0596515677 |
|
More Resources