SQL> connect / as sysdba
wywołujemy skrypt @
SQL> @C:\oraclexe\app\oracle\product\11.2.0\server\rdbms\admin>spcreate.sql
dla linuxa
/u01/app/oracle/product/11.2.0/db_1/rdbms/admin/spcreate.sql
wprowadzamy hasło
wprowadzamy tablespace SYSAUX
wprowadzamy tablespace TEMP
wybieramy poziom Statspack
SQL> select * from stats$level_description order by snap_level;
tworzenie,podglądanie i usuwanie migawek (snapshot)
SQL> connect perfstat/oracle
Connected.
SQL> exec statspack.snap
PL/SQL procedure successfully completed.
SQL> select name, snap_id, to_char(snap_time, 'MM-DD-YYYY:HH24:MI:SS')
2 "Date/Time" from stats$snapshot, v$database;
Przy usuwaniu migawki wybieramy jej ID
SQL> @?\rdbms\admin\sppurge;
Notes: prompted to enter low and high snapshot ID
Tworzymy raport
SQL> @?\rdbms\admin\spreport.sql
dla Linuxa
SQL> @/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/spreport.sql
Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 11
Begin Snapshot Id specified: 11
Enter value for end_snap: 21
End Snapshot Id specified: 21
Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is sp_11_21. To use this name,
press to continue, otherwise enter an alternative.
Enter value for report_name: Raport_migawki
Interpretacja wyników raportu to osobny temat
