Advanced Oracle SQL Tuning: The Definitive Reference

It's impossible to tune an Oracle database without understanding SQL tuning. Oracle is a SQL processing engine and the execution speed of any SQL query is influenced by many factors, both internal and external. As a declarative data access method, SQL relies on the Oracle cost-based optimizer to always choose the "best" execution plan for every SQL query. However, Oracle's SQL is among the most flexible and robust in the world, and along with this great power comes complexity. Tuning Oracle SQL is the single most important skill of any Oracle professional, and Oracle professionals are challenged to create SQL statements that will support thousands of concurrent executions with sub-second response time. "Advanced Oracle SQL Tuning" is a pragmatic treatment of Oracle SQL tuning, short on theory and big on real-world techniques and tips. This book is the culmination of the author's 25 years of full-time DBA experience and he shares expert tips and secrets for hyper charging SQL execution speed. This book covers advanced topics and it is not appropriate for beginners, dilettantes or neophytes.

• Oracle Tuning: The Definitive Reference
• Oracle Performance Troubleshooting: With Dictionary Internals SQL & Tuning Scripts (Oracle In-Focus) (Volume 36)
• Oracle Tuning Power Scripts: With 100+ High Performance SQL Scripts (Oracle In-Focus) (Volume 10)
• OCA Oracle Database SQL Exam Guide (Exam 1Z0-071) (Oracle Press)
• Predictive Analytics Using Oracle Data Miner: Develop & Use Data Mining Models in Oracle Data Miner, SQL & PL/SQL
• OCA/OCP Oracle Database 12c All-in-One Exam Guide (Exams 1Z0-061, 1Z0-062, & 1Z0-063)
• Oracle RMAN Database Duplication
• Oracle Database Problem Solving and Troubleshooting Handbook
• Pro Oracle GoldenGate for the DBA
• Oracle PL/SQL Programming: Covers Versions Through Oracle Database 12c