The BACKGROUND installation proceeds as follows:

$sqlplus

SQL>connect / as sysdba

SQL>define DEFAULT tablespace='PERFSTAT'

SQL>define temporary tablespace='PSAPTEMP'

SQL>define perfstat password=perfstat

SQL>@?/rdbms/admin/spcreate.sql

The PERFSTAT tablespace must already have been created.

SYSTEM is not allowed as a default tablespace.

Interactive installation:

$sqlplus

SQL>connect / as sysdba

SQL>@?/rdbms/admin/spcreate.sql

The interactive installation requires that you enter the password, the default tablespace as well as the temporary tablespace of the PERFSTAT database user.

The EXECUTION of the spcreate.sql script executes three scripts one after the other (spcusr.sql, spctab.sql, spcpkg.sql). The system creates three log FILES (spcusr.lis, spctab.lis, spcpkg.lis) in the current directory. You should check these for the occurrence of errors during the installation. After that, you can delete them.

After you install the statspack, we recommend that you change the password for the PERFSTAT user.

SQL>alter user perfstat identified by

The background installation proceeds as follows:

$sqlplus

SQL>connect / as sysdba

SQL>define default tablespace='PERFSTAT'

SQL>define temporary tablespace='PSAPTEMP'

SQL>define perfstat password=perfstat

SQL>@?/rdbms/admin/spcreate.sql

The PERFSTAT tablespace must already have been created.

SYSTEM is not allowed as a default tablespace.

Interactive installation:

$sqlplus

SQL>connect / as sysdba

SQL>@?/rdbms/admin/spcreate.sql

The interactive installation requires that you enter the password, the default tablespace as well as the temporary tablespace of the PERFSTAT database user.

The execution of the spcreate.sql script executes three scripts one after the other (spcusr.sql, spctab.sql, spcpkg.sql). The system creates three log files (spcusr.lis, spctab.lis, spcpkg.lis) in the current directory. You should check these for the occurrence of errors during the installation. After that, you can delete them.

After you install the statspack, we recommend that you change the password for the PERFSTAT user.

SQL>alter user perfstat identified by