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) |
MARC
| LEADER | 00000cam a2200000Mu 4500 | ||
|---|---|---|---|
| 001 | OR_ocn775301469 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr |n|---||||| | ||
| 008 | 120206s2007 xx o 000 0 eng d | ||
| 040 | |a EBLCP |b eng |e pn |c EBLCP |d OCLCQ |d ORMDA |d OCLCF |d OCLCO |d OCLCQ |d OCLCO | ||
| 020 | |a 9780596515676 | ||
| 020 | |a 0596515677 | ||
| 035 | |a (OCoLC)775301469 | ||
| 037 | |a 9780596515676 |b O'Reilly Media | ||
| 050 | 4 | |a QA76.9.D3 | |
| 082 | 0 | 4 | |a 005.75 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Gurry, Mark. | |
| 245 | 1 | 0 | |a Oracle Performance Tuning. |
| 250 | |a 2nd ed. | ||
| 260 | |a Sebastopol : |b O'Reilly Media, Inc., |c 2007. | ||
| 300 | |a 1 online resource (964 pages) | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 505 | 0 | |a 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. | |
| 505 | 8 | |a 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. | |
| 505 | 8 | |a 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. | |
| 505 | 8 | |a 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. | |
| 505 | 8 | |a 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. | |
| 500 | |a Parallel Server Locking? 525. | ||
| 520 | |a 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. | ||
| 588 | 0 | |a Print version record. | |
| 590 | |a O'Reilly |b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 630 | 0 | 0 | |a Oracle (Computer file) |
| 630 | 0 | 7 | |a Oracle (Computer file) |2 fast |
| 650 | 0 | |a Relational databases. | |
| 650 | 0 | |a Database management. | |
| 650 | 0 | |a SQL (Computer program language) | |
| 650 | 4 | |a Database management. | |
| 650 | 4 | |a Oracle (Computer file) | |
| 650 | 4 | |a Relational databases. | |
| 650 | 4 | |a SQL (Computer program language) | |
| 650 | 4 | |a Computer science. | |
| 650 | 6 | |a Bases de données relationnelles. | |
| 650 | 6 | |a Bases de données |x Gestion. | |
| 650 | 6 | |a SQL (Langage de programmation) | |
| 650 | 7 | |a Database management |2 fast | |
| 650 | 7 | |a Relational databases |2 fast | |
| 650 | 7 | |a SQL (Computer program language) |2 fast | |
| 700 | 1 | |a Corrigan, Peter. | |
| 776 | 0 | 8 | |i Print version: |a Gurry, Mark. |t Oracle Performance Tuning. |d Sebastopol : O'Reilly Media, Inc., ©2007 |z 9781565922372 |
| 856 | 4 | 0 | |u https://learning.oreilly.com/library/view/~/9780596515676/?ar |z Texto completo (Requiere registro previo con correo institucional) |
| 938 | |a ProQuest Ebook Central |b EBLB |n EBL540469 | ||
| 994 | |a 92 |b IZTAP | ||