Pages

Wednesday, May 9, 2012

Top 15 sqls from cursor and Workload repository

from Oracle 10g release there is a script named SQLTRPT.SQL at ORACLE_HOME/rdbms/admin
which lists top 15 sqls from cache cursor and workload repository and its Tuning recommendations.

SQL>  col SQL_TEXT_FRAGMENT for a67
SQL> set pages 999
SQL> @sqltrpt

--DUE TO CLUMSY FORMAT here removed from display--
 
Specify the Sql id
~~~~~~~~~~~~~~~~~~
Enter value for sqlid: b6usrg82hwsa3

Sql Id specified: b6usrg82hwsa3

Tune the sql
~~~~~~~~~~~~

GENERAL INFORMATION SECTION
-------------------------------------------------------------------------------
Tuning Task Name                  : TASK_331359
Tuning Task Owner                 : SYS
Scope                             : COMPREHENSIVE
Time Limit(seconds)               : 1800
Completion Status                 : COMPLETED
Started at                        : 05/08/2012 17:54:55
Completed at                      : 05/08/2012 17:54:55

-------------------------------------------------------------------------------
Schema Name: SYS
SQL ID     : b6usrg82hwsa3
SQL Text   : call dbms_stats.gather_database_stats_job_proc (  )

-------------------------------------------------------------------------------
ADDITIONAL INFORMATION SECTION
-------------------------------------------------------------------------------
- Type of SQL statement not supported.

-------------------------------------------------------------------------------



No comments:

Post a Comment