For database administrators and application developers, application tuning is a critically important area and a considerable amount of their time is spent performing this very important function. A poorly tuned business application can potentially affect not just a few users but an entire business operation and for this reason companies invest significant resources to ensure smooth running of applications vital for their businesses. Oracle Tuning Pack, a part of Oracle Database 10g product set, offers an extremely cost effective and easy-to-use solution that automates the entire application tuning process. Automatic SQL tuning is exposed to the user through two new components, SQL Tuning Advisor and SQL Access Advisor, that are seamlessly integrated with the Enterprise Manager Database Control and Grid Control, and together provide a comprehensive solution for automating the complex and time-consuming task of application tuning.
