SQL Monitor report now supports Adaptive plans. In-memory statistics in SQL Monitor report: Activity % in Time and Wait Statistics panel, Activity column in Plan Statistics table, and Activity tab in SQL Monitor report show CPU consumed by SQL commands while executing in-memory query operations. SQL Monitor report, ASH report, and AWR report now show statistics for various in-memory operations. The new Oracle Database In-Memory Column Store (IM column store) feature accelerates database performance of analytics, data warehousing, and online transaction processing (OLTP) applications. Manageability support for In-Memory Column Store
Learn to identify poorly performing SQL statements using real-time SQL monitoring and application tracing techniques such as DBMS_MONITOR(), trcsess and tkprof.The following features are new in this release:. Employ SQL hints embedded into the statement text to resolve unique tuning challenges. Understand the self-tuning infrastructure and the automatic SQL tuning capabilities found within the database. Demonstrate plan management to achieve plan stability which is adaptive and even dynamic. Utilize the database advisory framework and the SQL Tuning and SQL Access advisors. Influence the behavior of the Optimizer by setting database parameters and other SQL tuning techniques. Become trained in how statistic deficiencies can dramatically degrade performance, and how these problems are resolved through customized Optimizer statistics collection procedures using the DBMS_STATS() package, system statistics, histograms, expression statistics and MultiColumn statistics. Learn about the Auto-Task framework and how to manage the automatic collection of Optimizer statistics and automatic SQL tuning using both the programmatic and Enterprise Manager interfaces. Use a variety of techniques to examine the details of SQL statement execution, spotting trouble areas and bottlenecks which require tuning. 
Learn about the internal mechanisms use for SQL statement execution within a database instance and how these can affect performance for good or bad, including the Optimizer facilities known as the Transformation Engine, Estimator and Plan Generator. 
Consider the unique and differing tuning issues found in online database applications, enterprise resource and data warehouse environments and the important metrics of SQL statement performance.Upon completion of the Oracle Database 11g: SQL Tuning course, students will be able to:
0 kommentar(er)
