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 The database generates performance statistics, and provides SQL tuning tools that interpret these statistics. Oracle Database 2 Day + Performance Tuning Guide provides an introduction to the principal SQL tuning tools. ![]() The specifics of a tuning session depend on many factors, including whether you tune proactively or reactively. In proactive SQL tuning, you regularly use SQL Tuning Advisor to determine whether you can make SQL statements perform better. 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. Review past execution history to find the statements responsible for a large share of the application workload and system resources. ![]() The optimizer statistics are crucial to SQL tuning. ![]() If these statistics do not exist or are no longer accurate, then the optimizer cannot generate the best plan.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |