Oracle Performance Tuning for 10gR2, Second Edition
and over 360,000 other books are available for Amazon Kindle – Amazon’s new wireless reading device.
Learn more
| |||||||||||||||
Frequently Bought Together
Customers Who Bought This Item Also Bought
by Christian Antognini
|
by Matthew Hart
|
Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions by Thomas Kyte |
by Nitin Vengurlekar
|
RMAN Recipes for Oracle Database 11g : A Problem-Solution Approach (Expert's Voice in Oracle) by Darl Kuhn |
Editorial Reviews
Book Description
A completely revised version containing updates through to Oracle10gR2. Still includes critical 9i features
Product Description
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 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
Product Details
Would you like to update product info or give feedback on images?
|
Inside This Book
(learn more)
Key Phrases - Statistically Improbable Phrases (SIPs):
(learn more)
net services, oracle instance, shared servers, transaction control, latch name, top sessions, undo management, xfk coa, from generalledger, xpk type, unique index hit, most significant latches, xpk generalledger, generic static entities, xpk coa, database buffer cache hit ratio, join ordersline, mutable join, xpk stockmovement, session connection memory, row cache lock, control file heartbeat, full physical scans, temporary sort space, small static tables Key Phrases - Capitalized Phrases (CAPs): (learn more)
Oracle Database, Query Cost Rows Bytes, Database Control, Significant Events, Oracle Enterprise Manager, Types of Indexes, Tuning Oracle, Undoing Normalization, Layperson's Approach, Tuning Advisor, Total Time, Cost-Based Optimization, Access Advisor, Index Tuning Wizard, Gavin Powell, Digital Press, Oracle Partitioning, Influencing the Optimizer, Oracle Corporation, Using Functions, Oracle Streams, Oracle Expert, Memory Advisor, Special Cases, Advisor Central New!
Books on Related Topics Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Surprise Me!
net services, oracle instance, shared servers, transaction control, latch name, top sessions, undo management, xfk coa, from generalledger, xpk type, unique index hit, most significant latches, xpk generalledger, generic static entities, xpk coa, database buffer cache hit ratio, join ordersline, mutable join, xpk stockmovement, session connection memory, row cache lock, control file heartbeat, full physical scans, temporary sort space, small static tables Key Phrases - Capitalized Phrases (CAPs): (learn more)
Oracle Database, Query Cost Rows Bytes, Database Control, Significant Events, Oracle Enterprise Manager, Types of Indexes, Tuning Oracle, Undoing Normalization, Layperson's Approach, Tuning Advisor, Total Time, Cost-Based Optimization, Access Advisor, Index Tuning Wizard, Gavin Powell, Digital Press, Oracle Partitioning, Influencing the Optimizer, Oracle Corporation, Using Functions, Oracle Streams, Oracle Expert, Memory Advisor, Special Cases, Advisor Central New!
Books on Related Topics Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Surprise Me!
What Do Customers Ultimately Buy After Viewing This Item?
 |
48% buy the item featured on this page: Oracle Performance Tuning for 10gR2, Second Edition $71.95 |
 |
32% buy Oracle Database 10g Performance Tuning Tips & Techniques (Osborne ORACLE Press Series) $37.79 |
 |
8% buy Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning (Osborne ORACLE Press Series) $34.32 |
 |
8% buy Troubleshooting Oracle Performance $47.99 |
Suggested Tags from Similar Products(What's this?)Be the first one to add a relevant tag (keyword that's strongly related to this product).
|
Customer Reviews
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
Most Helpful Customer Reviews
Share your thoughts with other customers: Create your own review
|
 |
Customer Discussions
|
This product's forum
Active discussions in related forums
Search Customer Discussions
|
Listmania!
|
|
So You'd Like to...
Product Information from the Amapedia Community
Beta (What's this?)Be the first person to add an article about this item at Amapedia.com.
› See featured Amapedia.com articles
Look for Similar Items by Category
Look for Similar Items by Subject
Your Recent History
(What's this?)|
After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in. |
