silviacolasanti.it
» » Oracle SQL High-Performance Tuning (2nd Edition)

Download Oracle SQL High-Performance Tuning (2nd Edition) fb2, epub

by Guy Harrison

Download Oracle SQL High-Performance Tuning (2nd Edition) fb2, epub

ISBN: 0130123811
Author: Guy Harrison
Language: English
Publisher: Prentice Hall; 2 edition (January 8, 2001)
Pages: 656
Category: Databases & Big Data
Subcategory: IT
Rating: 4.5
Votes: 779
Size Fb2: 1867 kb
Size ePub: 1628 kb
Size Djvu: 1632 kb
Other formats: lrf mbr lrf rtf


Expert Oracle developer Guy Harrison gives Oracle developers and DBAs a single source for guidance on every aspect of Oracle 8/8i SQL and PL/SQL tuning, with specific recommendations, detailed case studies, and real benchmarks.

Oracle SQL High-Performance Tuning book Expert Oracle developer Guy Harrison gives Oracle developers an. .

Oracle SQL High-Performance Tuning book. Expert Oracle developer Guy Harrison gives Oracle developers and DBAs a single source for guidance on every aspect of Oracle 8/8i SQL and PL/SQL tuning, with specific recommendations, detailed case studies, and real benchmarks.

Expert Oracle developer Guy Harrison gives Oracle developers and DBAs a single source for guidance on every aspect of Oracle 8/8i SQL and PL/SQL tuning, with specific recommendations, detailed case studies, and real benchmarks. Targets the Oracle performance bottleneck: SQL and PL/SQL. For all releases through Oracle 8i. Detailed case studies and performance measurements. Large-volume queries, Oracle clusters, Java, parallel query tuning, and much more.

This book is about tuning Oracle databases and applications with an emphasis on th. Coverage includes: Designing applications to maximize efficiency right from the start. Building indexes that support high-performance queries. This book is about tuning Oracle databases and applications with an emphasis on the tuning of SQL statements.

book by Guy Harrison.

Why Tune SQL? The Place of SQL Tuning in the Overall Tuning Process. When Should SQL be Tuned?

Guy Harrison, Independent ORACLE Consultant, Los Angeles,. Why Tune SQL? The Place of SQL Tuning in the Overall Tuning Process. When Should SQL be Tuned?

Expert Oracle developer Guy Harrison gives Oracle developers and DBAs a single source for guidance on every aspect of Oracle 8i SQL and PL/SQL tuning. Harrison begins with a detailed overview of SQL processing in Oracle, and then introduces SQL tuning guidelines that improve virtually any application.

Expert Oracle developer Guy Harrison gives Oracle developers and DBAs a single source for guidance on every aspect of Oracle 8i SQL and PL/SQL tuning.

Oracle SQL high-performance tuning. by. Harrison, Guy. Publication date. Oracle (Computer file), Relational databases. Upper Saddle River, .

*Targets the no.1 Oracle performance bottleneck: SQL and PL/SQL *For all releases through Oracle 8i *Detailed case studies and performance measurements *Large-volume queries, Oracle clusters, Java, parallel query tuning, and much more Your one-stop resource for all Oracle SQL and PL/SQL tuning and optimization! Optimizing SQL code is the no.1 factor in improving Oracle database performance, yet most guides to Oracle tuning virtually ignore SQL. Oracle SQL High Performance Tuning, Second Edition zeroes in on SQL and PL/SQL, demonstrating how to achieve performance gains of 100% or more in many applications. Expert Oracle developer Guy Harrison gives Oracle developers and DBAs a single source for guidance on every aspect of Oracle 8/8i SQL and PL/SQL tuning, with specific recommendations, detailed case studies, and real benchmarks. Coverage includes: *Designing applications to maximize efficiency right from the start *Building indexes that support high-performance queries *Identifying and resolving Oracle Server bottlenecks *Fixing poorly performing SQL code *Identifying opportunities to substitute PL/SQL or Java for SQL *Making the most of Oracles tuning tools, including tkprof and

Comments:

Pipet
This is a MUST HAVE book if you're writing lots of SQL (in Oracle) and need to make sure it is as efficient as possible. Lots of real-world examples, with side-by-side comparisons of different queries that all produce the same result via different methods. It is easy to apply these techniques in my work. I have six books from Oracle Press, and while they are good as reference material, I find myself using them basically for syntax or server tuning, and never for PL/SQL tuning. Guy Harrison's book is a permanent fixture on my desk; this book covers table access methods, how to avoid unnecessary table scans, how to use TKPROF (with some excellent ratios and things to look for in the output), etc. The list goes on. I would strongly recommend this to anyone who writes SQL (in Oracle) on a daily basis.
Cells
I have read this book cover to cover and more. I have been using this book since 1998 and I still have to say it is good book.It is one of the Oracle Classics. It is a little outdated. If you look at the cover it clearly states it covers to oracle 8i. If you still have 8i databases this is a good book. if you are using 9i and cost based optimization it is still useful but it will not pick up on some of the newer fetures of the CBO. If you use Rule based optimization(RBO) than it is a good book. I had actually used this book as a teaching guide when I use to teach SQL Tuning for an application software company who uses oracle database. I look forward to when the revised version does ship.
Whitestone
This book begins with the basic rationals for tuning SQL. It points out that tuning SQL offers the most significant opportunity for performance gains in an SQL application. It covers the tools used for query tuning and then procedes to business. There is a chapter on tuning queries that run against a single table. Next is a chapter on tuning queries that use joins. Then there is a chapter on tuning sorts and aggregates and so on. With this material, you can classify your query and then move to the authors advice on tuning it. The are also case studies on query tuning that illustrate the process involved in tuning queries. There is also some abreviated material on designing a high performance Oracle server and some information on tuning the SGA.
greed style
Except for some missing hints (pg. 57-59) and some mixed up hint syntax, I found the book accurate and very enlightening. I've now used it on two from-scratch VLDB projects. Almost every page has something I was able to use to refine SQL statements & PL/SQL server-side code. For example, pg. 206, the section on MAX & MIN statements was the key to my latest project being able to process 20X the number of records we currently do. The section on learning to read tkprof output was helpful. The bibliography was also great (but is probably outdated now). Worth every penny!
Topmen
I love this book. Highly readable, it makes previously hard-to-grasp concepts, such as rule vs. cost-based optimization, tuning hints, etc, finally comprehensible. I've only started reading, but so far I have been able to assemble many months worth of garbled concepts and half-understandings into a much more cohesive unit of knowledge. Of all my books that discuss SQL tuning, this one is the best by far. Thank you Guy Harrison!
Ndyardin
A great book for beginners or advanced Oracle users. It really provides a wider array of information than just tuning- from logical structuring of the data to a review of basic SQL to advanced tuning concepts. Information is provided in short bursts, making it very readable and easy to "digest". About as "breezy" as a technical book can get.
Dalarin
I've been doing SQL tuning for Oracle Applications for some time. I read this book once and I use it as my main reference for SQL tuning. I am reading it again for the second time now. It is very useful and easy to read. If you are planning to do some Oracle SQL tuning, this book is a must!
Except for some typos, this is a very good Oracle SQL tuning book. Even the Appendix F is useful. I recommend it to Oracle SQL developers and Oracle DBAs.

Related to Oracle SQL High-Performance Tuning (2nd Edition)

Download Working With Oracle Version 6.0 fb2, epub

Working With Oracle Version 6.0 fb2 epub

Author: Carolyn J. Hursch,Jack L. Hursch
Category: Databases & Big Data
ISBN: 0830632468
Download Oracle XSQL: Combining SQL, Oracle Text, XSLT, and Java to Publish Dynamic Web Content fb2, epub

Oracle XSQL: Combining SQL, Oracle Text, XSLT, and Java to Publish Dynamic Web Content fb2 epub

Author: Michael D. Thomas
Category: Databases & Big Data
ISBN: 0471271209
Download ORACLE 7.0: Administration  Management (Wiley-Qed Enterprise Computing) fb2, epub

ORACLE 7.0: Administration Management (Wiley-Qed Enterprise Computing) fb2 epub

Author: Michael R. Ault
Category: Databases & Big Data
ISBN: 0471608572
Download Oracle Database 11g Release 2 Performance Tuning Tips  Techniques (Oracle Press) fb2, epub

Oracle Database 11g Release 2 Performance Tuning Tips Techniques (Oracle Press) fb2 epub

Author: Richard Niemiec
Category: Databases & Big Data
ISBN: 0071780262
Download Oracle Forensics: Oracle Security Best Practices (Oracle In-Focus series) (Volume 26) fb2, epub

Oracle Forensics: Oracle Security Best Practices (Oracle In-Focus series) (Volume 26) fb2 epub

Author: Paul M. Wright,Donald Burleson
Category: Certification
ISBN: 0977671526
Download Oracle Forms Interactive Workbook fb2, epub

Oracle Forms Interactive Workbook fb2 epub

Author: Baman Motivala
Category: Networking & Cloud Computing
ISBN: 0130158089
Download Oracle Procure-to-Pay Guide (Oracle Press) fb2, epub

Oracle Procure-to-Pay Guide (Oracle Press) fb2 epub

Author: Melanie Anjele Cameron
Category: Processes & Infrastructure
ISBN: 0071622276
Download Implementing and Managing Oracle Databases fb2, epub

Implementing and Managing Oracle Databases fb2 epub

Author: John Colby,Steve Lemme
Category: Databases & Big Data
ISBN: 0761529365
Download Commercial Applications Development Using ORACLE: Developer 9IDS and ORACLE 9IAS on LINUX fb2, epub

Commercial Applications Development Using ORACLE: Developer 9IDS and ORACLE 9IAS on LINUX fb2 epub

Author: I. Bayross
Category: Operating Systems
ISBN: 8176568708