SPREPORT CONFIGURATION STEPS

1. Create PERFSTAT Tablespace:

      CREATE TABLESPACE perfstat

        DATAFILE '/wms_data04/orawms/LGWMS/system/perfstat01.dbf' SIZE 1000M;

2. Run the following Script:

      @?/rdbms/admin/spcreate.sql;

3. Choose the parameters as follows:

     - PERFSTAT user's password - perfstat

     - Default tablespace – PERFSTAT

     - Temporary tablespace

4. Set the STATSPACK Level:

      Conn perfstat/perfstat       

      exec statspack.snap(i_snap_level => 7, i_modify_parameter => 'true');

5. View the STATSPACK Level by using following query:

      Select SNAP_LEVEL from STATS$SNAPSHOT;

6. Create and View Snapshot:

      Conn perfstat/perfstat

      exec statspack.snap;

      Select name,snap_id,to_char(snap_time,'DD.MM.YYYY:HH24:MI:SS')

                         "Date/Time" from stats$snapshot,v$database;

7. Run the following script to schedule snapshot collections on every hour:

   

      Conn perfstat/perfstat

      @?/rdbms/admin/spauto.sql;