This course will help you explore Oracle SQL statement tuning. Learn how to write well-tuned SQL statements appropriate for the Oracle database. This course will help you understand the process of SQL as it is executed in an Oracle Database. You learn to write well tuned SQL statements and utilize tools, such as cost-based optimizer, to execute a more efficient SQL process within an Oracle Database..
On successful Completion of this course you will be able to:
Introduction to SQL Tuning
Using Application Tracing Tools
Optimizer Fundamentals
Generating and Displaying Execution Plans
Interpreting Execution Plans and Enhancements
Optimizer: Join Operators
Other Optimizer Operators
Introduction to Optimizer Statistics Concepts
Using Bind Variables
SQL Plan Management
Oracle Database 19c SQL Tuning for Developers eLearning