Installing StatsPack

Firstly, this operation requires SYSDBA privileges (the modern day equivalent of CONNECT INTERNAL). This is granted by making the unix user a member of the ORACLE dba unix group. It probably makes more sense to perform this under the oracle unix account itself as the script will attempt to create spool files in that directory.

Change directory to $ORACLE_HOME/rdbms/admin, log in to SQL*Plus with SYSDBA privileges and run the following script:
spcreate.sql

This will prompt for the default and temporary tablespaces for the PERFSTAT user, plus the password for the user too.

That done, we should now be in a position to get some serious development under way.