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.
-------------------------------------------------------------------------------
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