To install Statspack in batch mode, you must assign values to the SQL*Plus variables that specify the default and temporary tablespaces before running SPCREATE.SQL. The variables are:
* DEFAULT_TABLESPACE: For the default tablespace
* TEMPORARY_TABLESPACE: For the temporary tablespace
* PERFSTAT_PASSWORD: For the PERFSTAT user
For example, on UNIX:
SQL> CONNECT / AS SYSDBA
SQL> define default_tablespace=’TOOLS’
SQL> define [...]
Filed under: Performance Tuning | Tagged: Installation, Statspack | Leave a Comment »
