SQL Tuning Advisor in Oracle Cloud Infrastructure Database Management
на канале: Oracle Cloud Observability and Management Platform
An important element of database system performance tuning is the tuning of SQL statements, which involves 3 basic steps:
- Identifying high load or Top SQL Statements that are responsible for a large share of application workload and system resources
- Verify the execution plans produced by the query optimizer for those loads
- Implement corrective actions to generate better execution plans for poorly performing SQL statements.
This is where SQL Tuning Advisor comes in. After analyzing the SQL statements, the SQL Tuning Advisor publishes various recommendations. Specifically it produces:
- Advice on optimizing the execution plan and it's rationale
- Estimated performance benefits
- The SQL statement to implement the advice
This demo will show you how this works in the Database Management service so you can fix performance problems throughout the lifecycle from design, coding and maintenance.
For more information, visit https://www.oracle.com/manageability
