SQLTRPT - SQL Tuning Advisor for the sql_id
Esempio fare sql tuning di 1w1r2psjrds21
# sqlplus
Enter user-name: /as sysdba
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
##creare un file di spool dove scrivere l'esito dell'Advisor
SQL> spool sqltrpt_1w1r2psjrds21.txt
SQL> @?/rdbms/admin/sqltrpt.sql
15 Most expensive SQL in the cursor cache
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
SQL_ID ELAPSED SQL_TEXT_FRAGMENT
------------- ---------- ----------------------
.....
...
##### Viene chiesto di inserire sqlid
Specify the Sql id
~~~~~~~~~~~~~~~~~~
Enter value for sqlid: 1w1r2psjrds21
Sql Id specified: 1w1r2psjrds21
Tune the sql
.......
SQL> spool off;