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 temporary_tablespace=’TEMP’
SQL> define perfstat_password=’my_perfstat_password’
SQL> @?/rdbms/admin/spcreate
When SPCREATE.SQL is run, it does not prompt for the information provided by the variables.
Reference:
1. http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96533/statspac.htm#21667
2. http://www.akadia.com/services/ora_statspack_survival_guide.html
Filed under: Performance Tuning | Tagged: Installation, Statspack
