How to Install Statspack (8i/9i/10g)

On UNIX:
SQL> CONNECT / AS SYSDBA
SQL> @?/rdbms/admin/spcreate

On NT:
SQL> CONNECT / AS SYSDBA
SQL> @%ORACLE_HOME%\rdbms\admin\spcreate

The SPCREATE install script runs three other scripts. These scripts are called automatically

* SPCUSR: Creates the user and grants privileges
* SPCTAB: Creates the tables
* SPCPKG: Creates the package