SQL> create tablespace spack datafile 'C:\oracle\product\10.2.0\oradata\dba20\SPAAC01.DBF' size 2M; Tablespace created.
SQL> show parameter timed_statistics; NAME TYPE VALUE ------------------------------------ ----------- -------- timed_statistics boolean TRUE
If False: SQL> alter system set timed_statistics=true; System altered.
SQL> @C:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\spcreate.sql Enter value for perfstat_password: perfstat
Enter value for default_tablespace: spack
Enter value for temporary_tablespace: temp
SQL> exec statspack.snap PL/SQL procedure successfully completed.
Pass long amount of time.
SQL> exec statspack.snap PL/SQL procedure successfully completed.
SQL> exec statspack.snap PL/SQL procedure successfully completed.
SQL> conn perfstat/perfstat Connected.
SQL> @C:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\spreport.sql Enter value for begin_snap: 1 Enter value for end_snap: 2 Enter value for report_name: d:\SPreport
Statspack Output:
|