SQL PERFORMANCE TUNING IN ORACLE 10g AND 11g
Preeti Singh Bhadoria, Ayushi Chhabra, Sanjay Ojha · 2014
Abstract: Oracle Database 10g introduced SQL Advisor to simplify application and provides for SQL tuning which was considered as an advantage over the already existing Oracle 9i. Oracle 10g had greater advantages when it came to performing the root-cause analysis of one or SQL statements. It also involved one of the major disadvantages of involving several manual steps. This came in as major problem to the DBA’s who had the tedious task of reviewing and testing the same, themselves. This issue was resolved with the introduction of the Oracle 11g that had the feature of the Automatic SQL Tuning, Real-time SQL Monitoring and Partition Advisor component of SQL Access Advisor that improved the performance problems without the DBA intervention.