ISBN 9789339222369,Oracle Pl/Sql Performance Tuning Tips & Techniques

Oracle Pl/Sql Performance Tuning Tips & Techniques



Tata McGraw - Hill Education

Publication Year 2015

ISBN 9789339222369

ISBN-10 9339222369


Number of Pages 336 Pages
Language (English)

Computer programming

In Oracle Pl/Sql : Performance Tuning Tips & Techniques, Oracle Ace Authors With Decades Of
Experience Building Complex Production Systems For Government, Industry, And Educational Organizations
Present A Handson Approach To Enabling Optimal Results From Pl/Sql. The Book Begins By
Describing The Discovery Process Required To Pinpoint Performance Problems And Then Provides
Measurable And Repeatable Test Cases. In-Depth Coverage Of Linking Sql And Pl/Sql Is Followed By Deep
Dives Into Essential Oracle Database Performance Tuning Tools. Real-World Examples And Best Practices
Are Included Throughout This Oracle Press Guide.
Salient Features:
- Use Performance-Related Database Tools, Including Data Dictionary Views, Logging, Tracing, Pl/Sql Hierarchical Profiler, Pl/Scope, And Runstats.
- Manage Version Control And Ensure That Performance Fixes Are Successfully Deployed.
- Work With Advanced Datatypes, Including Lobs And Xml

Table Of Contents:
Part 1. Core Ideas And Elements Of Pl/Sql Performance Tuning Introduction. 1. Role Of Pl/Sql In Contemporary Development 2. Dba/Developer Borderline: Tools/Features/Setup 3. Code Instrumentation In Pl/Sql Part 2. Linking Sql And Pl/Sql 4. Expanding The Sql Horizons 5. Thinking In Sets 6. Pulling The Trigger Part 3. Tuner'S Toolkit 7. Going Beyond Scalar Datatypes 8. Keeping The Cache 9. Shooting At A Moving Target Part4. Pl/Sql In Daily Life 10. Tales From The Trenches 11. Code Management In Real World Systems 12. Extra Tips, Tricks And Ideas