Oracle Performance Tuning for 10gR2
3/5
()
About this ebook
Tuning of SQL code is generally cheaper than changing the data model. Physical and configuration tuning involves a search for bottlenecks that often points to SQL code or data model issues. Building an appropriate data model and writing properly performing SQL code can give 100%+ performance improvement. Physical and configuration tuning often gives at most a 25% performance increase.
Gavin Powell shows that the central theme of Oracle10gR2 Performance Tuning is four-fold: denormalize data models to fit applications; tune SQL code according to both the data model and the application in relation to scalability; create a well-proportioned physical architecture at the time of initial Oracle installation; and most important, mix skill sets to obtain the best results.
- Fully updated for version 10gR2 and provides all necessary transition material from version 9i
- 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
Gavin JT Powell
Gavin Powell, BSc. Comp.Sci., OCP (Oracle8i Certified Professional) has fifteen years of computer industry experience. Diverse experience in database administration and database development in both relational and object databases. Applications development experience is procedural and object-oriented. He also has some systems administration experience. His extensive consulting experience includes software vendors, internet .COM’s (some unfortunately have met with their demise), accounting, banking, financial services, the travel industry, construction, retail, mining, shipping, education and general advisory capacity. Gavin Powell has worked with many software products, tools and programming languages. These tools include items in the list shown below. He has authored two successful books Oracle …High performance Tuning and the just released Oracle SQL
Read more from Gavin Jt Powell
Oracle SQL: Jumpstart with Examples Rating: 5 out of 5 stars5/5Oracle High Performance Tuning for 9i and 10g Rating: 3 out of 5 stars3/5Microsoft SQL Server 2005 Performance Optimization and Tuning Handbook Rating: 0 out of 5 stars0 ratingsOracle Data Warehouse Tuning for 10g Rating: 5 out of 5 stars5/5
Related to Oracle Performance Tuning for 10gR2
Related ebooks
Oracle GoldenGate 11g Implementer's guide Rating: 5 out of 5 stars5/5Oracle 10g RAC Grid, Services and Clustering Rating: 0 out of 5 stars0 ratingsOracle Database Programming using Java and Web Services Rating: 0 out of 5 stars0 ratingsOracle Database A Complete Guide - 2021 Edition Rating: 0 out of 5 stars0 ratingsOracle Cloud Infrastructure A Complete Guide - 2020 Edition Rating: 0 out of 5 stars0 ratingsPentaho Analytics for MongoDB Cookbook Rating: 0 out of 5 stars0 ratingsPostgreSQL 9 Administration Cookbook - Second Edition Rating: 0 out of 5 stars0 ratingsDB2 A Complete Guide - 2021 Edition Rating: 0 out of 5 stars0 ratingsPostgreSQL 9 High Availability Cookbook Rating: 5 out of 5 stars5/5Instant Oracle GoldenGate Rating: 0 out of 5 stars0 ratingsMigrating to the Cloud: Oracle Client/Server Modernization Rating: 0 out of 5 stars0 ratingsOracle Database Security Interview Questions, Answers, and Explanations: Oracle Database Security Certification Review Rating: 0 out of 5 stars0 ratingsOracle Database 11g R2 Performance Tuning Cookbook Rating: 0 out of 5 stars0 ratingsOracle 10g/11g Data and Database Management Utilities Rating: 0 out of 5 stars0 ratingsZabbix Performance Tuning Rating: 5 out of 5 stars5/5VMware Certified Professional Second Edition Rating: 1 out of 5 stars1/5Oracle Database 12c Security Cookbook Rating: 0 out of 5 stars0 ratingsLearning Windows Server Containers Rating: 0 out of 5 stars0 ratingsDevOps with Windows Server 2016 Rating: 0 out of 5 stars0 ratingsOracle Exalytics Revealed: E-Book Rating: 0 out of 5 stars0 ratingsMainframe Modernization A Complete Guide - 2019 Edition Rating: 0 out of 5 stars0 ratingsPostgreSQL Server Programming - Second Edition Rating: 0 out of 5 stars0 ratingsApache Mahout Clustering Designs Rating: 0 out of 5 stars0 ratingsPractical Oracle Cloud Infrastructure: Infrastructure as a Service, Autonomous Database, Managed Kubernetes, and Serverless Rating: 0 out of 5 stars0 ratingsOracle 11g Anti-hacker's Cookbook Rating: 5 out of 5 stars5/5Software Architecture Complete Self-Assessment Guide Rating: 0 out of 5 stars0 ratingsOracle 11g R1/R2 Real Application Clusters Essentials Rating: 5 out of 5 stars5/5Instant Pentaho Data Integration Kitchen Rating: 0 out of 5 stars0 ratingsDBAs Guide to Databases Under Linux Rating: 0 out of 5 stars0 ratingsDatabase Archiving: How to Keep Lots of Data for a Very Long Time Rating: 3 out of 5 stars3/5
Enterprise Applications For You
Scrivener For Dummies Rating: 4 out of 5 stars4/5Excel : The Ultimate Comprehensive Step-By-Step Guide to the Basics of Excel Programming: 1 Rating: 5 out of 5 stars5/5Systems Thinking: Managing Chaos and Complexity: A Platform for Designing Business Architecture Rating: 4 out of 5 stars4/5Excel 2019 For Dummies Rating: 3 out of 5 stars3/5Creating Online Courses with ChatGPT | A Step-by-Step Guide with Prompt Templates Rating: 4 out of 5 stars4/5Excel Formulas and Functions 2020: Excel Academy, #1 Rating: 4 out of 5 stars4/5ChatGPT Ultimate User Guide - How to Make Money Online Faster and More Precise Using AI Technology Rating: 0 out of 5 stars0 ratings50 Useful Excel Functions: Excel Essentials, #3 Rating: 5 out of 5 stars5/5Bitcoin For Dummies Rating: 4 out of 5 stars4/5QuickBooks 2023 All-in-One For Dummies Rating: 0 out of 5 stars0 ratingsQuickBooks Online For Dummies Rating: 0 out of 5 stars0 ratingsCreate Income through Self-Publishing: An Author's Approach on Generating Wealth by Self-Publishing Rating: 5 out of 5 stars5/5Excel 2016 For Dummies Rating: 4 out of 5 stars4/5Excel Formulas That Automate Tasks You No Longer Have Time For Rating: 5 out of 5 stars5/5QuickBooks 2021 For Dummies Rating: 0 out of 5 stars0 ratingsLearn Windows PowerShell in a Month of Lunches Rating: 0 out of 5 stars0 ratings101 Ready-to-Use Excel Formulas Rating: 4 out of 5 stars4/5Enterprise AI For Dummies Rating: 3 out of 5 stars3/5Notion for Beginners: Notion for Work, Play, and Productivity Rating: 4 out of 5 stars4/5CISSP Study Guide Rating: 4 out of 5 stars4/5102 Useful Excel 365 Functions: Excel 365 Essentials, #3 Rating: 0 out of 5 stars0 ratingsExcel : The Complete Ultimate Comprehensive Step-By-Step Guide To Learn Excel Programming Rating: 0 out of 5 stars0 ratingsExercises and Projects for The Little SAS Book, Sixth Edition Rating: 0 out of 5 stars0 ratingsLearning Python Rating: 5 out of 5 stars5/5The Ridiculously Simple Guide to Google Docs: A Practical Guide to Cloud-Based Word Processing Rating: 0 out of 5 stars0 ratings
Reviews for Oracle Performance Tuning for 10gR2
1 rating0 reviews