The optimizer statistics are crucial to SQL tuning. Review past execution history to find the statements responsible for a large share of the application workload and system resources. Whether you tune proactively or reactively, a typical SQL tuning session involves all or most of the following tasks: In reactive SQL tuning, you correct a SQL-related problem that a user has experienced. In proactive SQL tuning, you regularly use SQL Tuning Advisor to determine whether you can make SQL statements perform better. The specifics of a tuning session depend on many factors, including whether you tune proactively or reactively. Oracle Database 2 Day + Performance Tuning Guide provides an introduction to the principal SQL tuning tools.

The database generates performance statistics, and provides SQL tuning tools that interpret these statistics. You must also have a working knowledge of Oracle Database SQL Language Reference, Oracle Database PL/SQL Packages and Types Reference, and Oracle Database PL/SQL Packages and Types Reference.įamiliarity with database-provided SQL tuning tools

Oracle Database Concepts includes an introduction to Oracle SQL and PL/SQL. However, it is impossible to tune applications or a database without knowing SQL. Oracle Database Concepts explains the basic relational data structures, transaction management, storage structures, and instance architecture of Oracle Database.īecause of the existence of GUI-based tools, it is possible to create applications and administer a database without knowing SQL. For example, not understanding Oracle Database concurrency controls and multiversioning read consistency may make an application corrupt the integrity of the data, run slowly, and decrease scalability. As a developer, you want to develop applications in the least amount of time against an Oracle database, which requires exploiting the database architecture and features. If you are tuning SQL, then this manual assumes that you have the following knowledge and skills:ĭatabase architecture is not the domain of administrators alone.

Quest sql tuning for oracle