DanBrother的部落格

Installing and Configuring Statspack: (TESTDB as an example)

Create PERFSTAT tablespace:
CREATE TABLESPACE PERFSTAT
DATAFILE 'D:\ORACLE\ORADATA\TESTDB\PERFSTAT01.DBF' SIZE 200M
REUSE AUTOEXTEND ON NEXT 1M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512K PERMANENT ONLINE;

Run the Create Scripts:  (Under SYS Schema)
SQL> @?/rdbms/admin/catdbsyn.sql
SQL> @?/rdbms/admin/dbmspool.sql
SQL> @?/rdbms/admin/spcreate.sql

Create Snapshots:  (Under PERFSTAT Schema)
SQL> exec statspack.snap;     -- Begin Time
SQL> exec statspack.snap;     -- End Time

View Snapshots: (Under PERFSTAT Schema)
select name,snap_id,to_char(snap_time,'YYYY/MM/DD HH24:MI:SS') "Date/Time"
from stats$snapshot,v$database;

Delete Snapshots: (Under PERFSTAT Schema)
SQL> @?/rdbms/admin/sppurge;

Create the Snapshot Report:  (Under PERFSTAT Schema)
SQL> @?/rdbms/admin/spreport.sql

Remove STATSPACK from the Database:  (Under SYS Schema)
SQL> @?/rdbms/admin/spdrop.sql