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 www.oracle.com...
15 окт 2024