ScholarLens Back to search
2014•Unpublished venueRequires access

SQL PERFORMANCE TUNING IN ORACLE 10g AND 11g

Preeti Singh Bhadoria, Ayushi Chhabra, Sanjay Ojha

Open publisher page 1 citations

Abstract

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.

About this research paper

What this paper is about

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.

Why it matters

OpenAlex reports 1 citations for this work. Citation counts describe recorded attention and do not establish research quality.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available abstract

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.

Key concepts: PL/SQL, SQL/PSM, Computer science, SQL, SQL injection, Stored procedure, Data Transformation Services, Oracle

Related papers

Related paper 1Related paper 2Related paper 3
Back to paper searchBrowse research topicsOriginal source
SQL PERFORMANCE TUNING IN ORACLE 10g AND 11g — Research Paper | ScholarLens