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;