Oracle High Performance Tuning for 9i and 10g
eBook - PDF

Oracle High Performance Tuning for 9i and 10g

  1. 544 pages
  2. English
  3. PDF
  4. Available on iOS & Android
eBook - PDF

Oracle High Performance Tuning for 9i and 10g

Book details
Table of contents
Citations

About This Book

There are three parts to tuning an Oracle database: data modeling, SQL code tuning and physical database configuration.A data model contains tables and relationships between tables. Tuning a data model involves normalization and de-normalization. Different approaches are required depending on the application, such as OLTP or a Data Warehouse. Inappropriate database design can make SQL code impossible to tune. Poor data modeling can have a most profound effect on database performance since all SQL code is constructed from the data model. Poorly written SQL code is often a culprit of performance problems and is expensive to rectify. However, tuning of SQL code is generally cheaper than changing the data model. SQL code tends to be contained inside independent blocks within applications or stored procedures.Physical database tuning involves hardware resource usage, networking and various other Oracle things such as configuration and file distribution. Physical configuration is often a culprit of poor performance where Oracle is installed with defaults, and never altered by an expert.*Includes all three aspects of Oracle database tuning: data model tuning, SQL & PL/SQL code tuning, physical plus configuration tuning
*Contains experienced guidance and real-world examples using large datasets *Emphasizes development as opposed to operating system perspective

Frequently asked questions

Simply head over to the account section in settings and click on “Cancel Subscription” - it’s as simple as that. After you cancel, your membership will stay active for the remainder of the time you’ve paid for. Learn more here.
At the moment all of our mobile-responsive ePub books are available to download via the app. Most of our PDFs are also available to download and we're working on making the final remaining ones downloadable now. Learn more here.
Both plans give you full access to the library and all of Perlego’s features. The only differences are the price and subscription period: With the annual plan you’ll save around 30% compared to 12 months on the monthly plan.
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, we’ve got you covered! Learn more here.
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Yes, you can access Oracle High Performance Tuning for 9i and 10g by Gavin JT Powell in PDF and/or ePUB format, as well as other popular books in Computer Science & Databases. We have over one million books available in our catalogue for you to explore.

Information

Publisher
Digital Press
Year
2003
ISBN
9780080513294
Topic
Computer Science
Subtopic
Databases
Index
Computer Science

Table of contents

  1. Front Cover
  2. OracleÂŽ High Performance Tuning for 9i and 1og
  3. Copyright Page
  4. Contents
  5. Contents at a glance
  6. Preface
  7. Introduction
  8. Part I: Data Model Tuning
  9. Part II: SQL Code Tuning
  10. Part III: Physical and Configuration Tuning
  11. Appendix A. Sample Databases
  12. Appendix B. Sample Scripts
  13. Appendix C. Sources of Information
  14. Index