Utlbstat and utlestat script

SQL> show parameter timed_statistics;

 NAME                                 TYPE        VALUE

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

timed_statistics                     boolean     FALSE

 

SQL> alter system set timed_statistics=true;

 System altered.

 

SQL> @C:\oracle\ora92\rdbms\admin\utlbstat.sql

 

Pass long amount of time.

 

SQL> @C:\oracle\ora92\rdbms\admin\utlestat.sql;

By Default Script will store in current directory.

Comments