Oracle SQL High-Performance Tuning
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Home > Computing and Information Technology > Databases > Database software > Oracle SQL High-Performance Tuning
Oracle SQL High-Performance Tuning

Oracle SQL High-Performance Tuning


     0     
5
4
3
2
1



Out of Stock


Notify me when this book is in stock
X
About the Book

*Targets the #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 #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 per cent 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 Oracle's tuning tools, including tkprof and explain *Leveraging Oracle's parallel query facility for large-volume queries *Maximizing the performance of Oracle clusters Get all the performance and scalability you're paying for -- without investing in new hardware! Whether you're running OLAP or OLTP applications, Guy Harrison's Oracle SQL High Performance Tuning, Second Edition shows you how, step-by-step!

Table of Contents:
I. INTRODUCTION TO SQL TUNING. 1. Introduction to SQL Tuning. Introduction. Why Tune SQL? The Place of SQL Tuning in the Overall Tuning Process. When Should SQL be Tuned? The Tuning Process. Constructing a Tuning Environment. Tuning SQL. Summary. 2. SQL Tuning Quick Start. Introduction. Top Tips and Hints for SQL Tuning. SQL Tuning Quick Tips. 3. Review of SQL. Introduction. The History of SQL. Types of SQL Statements. Query Operations: The SELECT Statement. Data Manipulation and Transaction Control. Summary. II. SQL TUNING THEORY. 4. SQL Processing Internals. Introduction. Overview of SQL Processing. Creating and Parsing Cursors. The Cursor_Sharing Option in Oracle. Executing SQL. Types of Table Accesses. Joins. Sorting and Grouping. Modifying Data. Summary. 5. The Optimizer. Introduction. Overview of Optimization. Collecting Optimizer Statistics. Using Plan Stability. Using Hints. Using Hints to Change the Access Path. Using Hints to Change the Join Order. Errors in Hint Specifications. Summary. 6. Indexing and Clustering. Introduction. B*-tree Indexes. Clustering. Bitmap Indexes. Index Organized Tables. Summary. 7. Tracing and Explaining SQL. Introduction. Explain Plan. Using Explain Plan. SQL Trace. Overview of the SQL Tracing Process. Preparing to Use SQL Trace. Enabling SQL Trace Within a Session. Enabling SQL Trace from Another Session. Finding the Trace File. Using Tkprof. Tkprof Sort Options. Other Tkprof Options. Troubleshooting SQL_TRACE and Tkprof. Interpreting Tkprof Output. Tkprof Execution Statistics. Tkprof Execution Plans. Tuning SQL with Tkprof Output. Tkprof Rules, OK? The SQL*PLUS AUTOTRACE Option. Requirements for Using AUTOTRACE. Initiating AUTOTRACE. AUTOTRACE Output. AUTOTRACE Compared to Tkprof. Summary. III. SQL TUNING IN PRACTICE. 8. Tuning Table Access. Introduction. When to Use a Full-Table Scan. How the Optimizer Chooses Between Indexes _and Full-Table Scan. Column Histograms. Avoiding "Accidental" Table Scans. Not Equals Conditions. Searching For Nulls. Searching for Values That are NOT NULL. Creating Indexes on NULLable Columns. Searching for a Selective Value in an Unselective Column. Unintentionally Disabling an Index With a Function. Functional Indexes. Choosing the Best Indexing Strategy. How Many Distinct Values are Too Many For a Bitmap Index? Deciding To Use an Index Organized Table. Optimizing B*-tree Index Lookups. Types of Index Retrievals. Using Concatenated Indexes. Index Merges. Searching for Ranges. Optimizing Bitmap Index Access. Optimizing Hash Clusters. Optimizing Index Organized Tables. Optimizing Full Table Scans. Optimizing for the First Row. Summary. 9. Tuning Joins and Subqueries. Introduction. Choosing the Best Join Method. Optimizing the Join. Special Joins. Subqueries. Semijoins. Antijoins. Summary. 10. Sorts, Aggregates, and SET Operations. Introduction. Sort Operations. Aggregate Operations. SET Operations. Summary. 11. Parallel SQL. Introduction. Understanding Parallel SQL. Using Parallel Query. Tuning Parallel Query. Examples of Parallel Queries. Other Parallel Operations. Summary. 12. Optimizing DML. Introduction. General Optimizations. Optimizing INSERTS. Optimizing Transactions. Parallel DML. Summary. 13. VLDB and Warehousing. Introduction. Partitioning. Materialized Views and Snapshots. Summary. 14. Using and Tuning PL/SQL. Introduction. Performance Characteristics of PL/SQL. Using PL/SQL in Place of Standard SQL. Optimizing PL/SQL. Dynamic SQL and PL/SQL. Using the PL/SQL Profiler. Summary. 15. Using and Tuning Oracle Java. Introduction. Java as an Alternative to PL/SQL. Computationally Intensive Routines. Database-Intensive Routines. Java or PL/SQL? Using Bind Variables in JDBC. Cursor Handling. Avoid Autocommit. Using Array Processing (JDBC 1). Using Array Processing (JDBC 2). Using Oracle Datatypes. Bind Variables. Cursor Management. Array Processing. JDBC or SQJ or PL/SQL? Summary. 16. Oracle Object Types. Introduction. Object Type Alternatives to Master-Detail Tables. Performance Comparisons for Object Types. Summary. 17. Miscellaneous Topics. Introduction. Optimizing Views. Distributed SQL. Distributed Joins. Sequences. Using DECODE. Optimizing Data Definition Language. Tuning Access to the V$ Tables. Summary. IV. BEYOND SQL TUNING. 18. Application Design Issues. Introduction. Building Tuning into the Design Process. Establishing an Efficient Physical Model. Application Design. Summary. 19. Oracle Server Design. Introduction. A Review of the Oracle Architecture. Sizing the Host Computer. Essential Considerations for Database Configuration. Optimizing Database I/O. Sizing the SGA. Multithreaded Servers. Parallel Query Processes. Summary. 20. Oracle Server Tuning. Introduction. Evaluating Operating System Performance. Recognizing Oracle Database Bottlenecks. Identifying Resource Intensive SQL. Summary. Appendix A: Reference. Appendix B: Glossary. Appendix C: Configuring Development Tools. Appendix D: Oracle Server Configuration. Appendix E: Bibliography and Resources. Index.

About the Author :
GUY HARRISON has worked with Oracle databases for more than a decade, has conducted many Oracle training seminars, and is author of several books on Oracle, including Oracle Desk Reference (Prentice Hall PTR). Currently a product architect at Quest Software, Harrison has conducted many Oracle training seminars and has authored several articles for the Oracle Technical Journal. He resides in Australia.


Best Sellers


Product Details
  • ISBN-13: 9780130123817
  • Publisher: Pearson Education (US)
  • Publisher Imprint: Prentice Hall
  • Height: 178 mm
  • No of Pages: 656
  • ISBN-10: 0130123811
  • Publisher Date: 09 Jan 2001
  • Binding: Paperback
  • Language: English


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Oracle SQL High-Performance Tuning
Pearson Education (US) -
Oracle SQL High-Performance Tuning
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Oracle SQL High-Performance Tuning

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    Fresh on the Shelf


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!