Cargando…
Oracle Database 11gR2 Performance Tuning Cookbook.
In this book you will find both examples and theoretical concepts covered. Every recipe is based on a script/procedure explained step-by-step, with screenshots, while theoretical concepts are explained in the context of the recipe, to explain why a solution performs better than another. This book is...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham :
Packt Pub.,
2012.
|
| Temas: | |
| Acceso en línea: | Texto completo |
MARC
| LEADER | 00000cam a2200000Mu 4500 | ||
|---|---|---|---|
| 001 | EBOOKCENTRAL_ocn796384673 | ||
| 003 | OCoLC | ||
| 005 | 20240329122006.0 | ||
| 006 | m o d | ||
| 007 | cr unu|||||||| | ||
| 008 | 121121s2012 enk o 000 0 eng d | ||
| 040 | |a EBLCP |b eng |e pn |c EBLCP |d OCLCQ |d DEBSZ |d OCLCQ |d FEM |d ZCU |d MERUC |d ICG |d OCLCO |d OCLCF |d OCLCQ |d OCLCO |d OCLCQ |d OCLCO |d DKC |d OCLCQ |d OCLCO |d OCLCQ |d OCLCO |d OCLCL | ||
| 019 | |a 968042940 |a 969046880 | ||
| 020 | |a 9781849682619 | ||
| 020 | |a 1849682615 | ||
| 029 | 1 | |a AU@ |b 000053025233 | |
| 029 | 1 | |a DEBBG |b BV044166207 | |
| 029 | 1 | |a DEBSZ |b 397324049 | |
| 035 | |a (OCoLC)796384673 |z (OCoLC)968042940 |z (OCoLC)969046880 | ||
| 037 | |a 5068753946900743280 |b TotalBoox |f Ebook only |n www.totalboox.com | ||
| 050 | 4 | |a QA76.9.D3 | |
| 082 | 0 | 4 | |a 005.75/85 |a 005.7575 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Fiorillo, Ciro. | |
| 245 | 1 | 0 | |a Oracle Database 11gR2 Performance Tuning Cookbook. |
| 260 | |a Birmingham : |b Packt Pub., |c 2012. | ||
| 300 | |a 1 online resource (842 pages) | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 347 | |a text file |2 rda | ||
| 505 | 0 | |a Oracle Database 11gR2 Performance Tuning Cookbook; Oracle Database 11gR2 Performance Tuning Cookbook; Credits; About the Author; Acknowledgement; About the Reviewers; www.PacktPub.com; Support files, eBooks, discount offers and more; Why Subscribe?; Free Access for Packt account holders; Instant Updates on New Packt Books; Preface; What this book covers; What you need for this book; Who this book is for; Conventions; Reader feedback; Customer support; Downloading the example code; Errata; Piracy; Questions; 1. Starting with Performance Tuning; Introduction; Incorrect session management. | |
| 505 | 8 | |a Poorly designed cursor managementInadequate relational design; Improper use of storage structures; Reviewing the performance tuning process; How to do it ... ; How it works ... ; There's more ... ; See also; Exploring the example database; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Acquiring data using a data dictionary and dynamic performance views; Getting ready; How to do it ... ; How it works ... ; There's more ... ; See also; Analyzing data using Statspack reports; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Collecting different amounts of data. | |
| 505 | 8 | |a Producing a report on a specific SQLAutomating snapshot generation; Statspack maintenance; Diagnosing performance issues using the alert log; Getting ready; How to do it ... ; How it works ... ; There's more ... ; See also; Analyzing data using Automatic Workload Repository (AWR); Getting ready; How to do it ... ; How it works ... ; There's more ... ; Analyzing data using Automatic Database Diagnostic Monitor (ADDM); Getting ready; How to do it ... ; How it works ... ; There's more ... ; See also; A working example; Getting ready; How to do it ... ; How it works ... ; There's more ... ; See also. | |
| 505 | 8 | |a 2. Optimizing Application DesignIntroduction; Optimizing connection management; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Dedicated server versus shared server; Web applications; Client-server Online Transaction Processing; Batch processing; See also; Improving performance sharing reusable code; Getting ready; How to do it ... ; How it works ... ; There's more ... ; PL/SQL and parsing; Diagnosing soft and hard parsing; See also; Reducing the number of requests to the database using stored procedures; How to do it ... ; How it works ... ; There's more ... ; See also. | |
| 505 | 8 | |a Reducing the number of requests to the database using sequencesHow to do it ... ; How it works ... ; There's more ... ; Correct definition of a sequence; See also; Reducing the number of requests to the database using materialized views; How to do it ... ; How it works ... ; There's more ... ; Materialized views in depth; Materialized views and grants; Database parameters to use query rewrite; Can I use materialized views in an OLTP environment?; Optimizing performance with schema denormalization; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Not 1NF structures; Avoiding dynamic SQL. | |
| 520 | |a In this book you will find both examples and theoretical concepts covered. Every recipe is based on a script/procedure explained step-by-step, with screenshots, while theoretical concepts are explained in the context of the recipe, to explain why a solution performs better than another. This book is aimed at software developers, software and data architects, and DBAs who are using or are planning to use the Oracle Database, who have some experience and want to solve performance problems faster and in a rigorous way. If you are an architect who wants to design better applications, a DBA who is. | ||
| 588 | 0 | |a Print version record. | |
| 590 | |a ProQuest Ebook Central |b Ebook Central Academic Complete | ||
| 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 | 6 | |a Bases de données relationnelles. | |
| 650 | 6 | |a Bases de données |x Gestion. | |
| 650 | 7 | |a Database management |2 fast | |
| 650 | 7 | |a Relational databases |2 fast | |
| 758 | |i has work: |a Oracle Database 11gR2 performance tuning cookbook (Text) |1 https://id.oclc.org/worldcat/entity/E39PD3FHdcR9fy8fvT4RfHHgXb |4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 776 | 0 | 8 | |i Print version: |a Fiorillo, Ciro. |t Oracle Database 11gR2 Performance Tuning Cookbook. |d Birmingham : Packt Publishing, ©2012 |z 9781849682602 |
| 856 | 4 | 0 | |u https://ebookcentral.uam.elogim.com/lib/uam-ebooks/detail.action?docID=943418 |z Texto completo |
| 938 | |a EBL - Ebook Library |b EBLB |n EBL943418 | ||
| 994 | |a 92 |b IZTAP | ||