3 Review(s)

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