Oracle SQL Tuning Advisor 可以帮助DBA分析SQL执行的性能,并提出多种解决方案。
SQL Tunning Advisor的使用方法
- Enterprise Manager(提供图形界面)
- sqltrpt(针对单条SQL的诊断)
- DBMS_SQLTUNE包
参见官方http://docs.oracle.com/cd/E11882_01/server.112/e16638/sql_tune.htm#autoId24
步骤如下:
Create a SQL tuning set (if tuning multiple SQL statements)
Create a SQL tuning task
Execute a SQL tuning task
Display the results of a SQL tuning task
Implement recommendations as appropriate