Oracle Sql High-Performance Tuning (Prentice Hall Ptr Oracle Series) - Softcover

Über die Autorin bzw. den Autor

GUY HARRISON has worked with Oracle databases for more than a decade, has conducted many Oracle training seminars, and is author of several books on Oracle, including Oracle Desk Reference (Prentice Hall PTR). Currently a product architect at Quest Software, Harrison has conducted many Oracle training seminars and has authored several articles for the Oracle Technical Journal. He resides in Australia.

Von der hinteren Coverseite

• Targets the #1 Oracle performance bottleneck: SQL and PL/SQL
• For all releases through Oracle 8i
• Detailed case studies and performance measurements
• Large-volume queries, Oracle clusters, Java, parallel query tuning, and much more

Your one-stop resource for all Oracle SQL and PL/SQL tuning and optimization!

Optimizing SQL code is the #1 factor in improving Oracle database performance, yet most guides to Oracle tuning virtually ignore SQL. Oracle SQL High Performance Tuning, Second Edition zeroes in on SQL and PL/SQL, demonstrating how to achieve performance gains of 100% or more in many applications. Expert Oracle developer Guy Harrison gives Oracle developers and DBAs a single source for guidance on every aspect of Oracle 8/8i SQL and PL/SQL tuning, with specific recommendations, detailed case studies, and real benchmarks. Coverage includes:

• Designing applications to maximize efficiency right from the start
• Building indexes that support high-performance queries
• Identifying and resolving Oracle Server bottlenecks
• Fixing poorly performing SQL code
• Identifying opportunities to substitute PL/SQL or Java for SQL
• Making the most of Oracle's tuning tools, including tkprof and explain
• Leveraging Oracle's parallel query facility for large-volume queries
• Maximizing the performance of Oracle clusters

Get all the performance and scalability you're paying for — without investing in new hardware! Whether you're running OLAP or OLTP applications, Guy Harrison's Oracle SQL High Performance Tuning, Second Edition shows you how, step-by-step!