December 2002
Intermediate to advanced
928 pages
85h 29m
English
The objects used by Statspack are owned by the user PERFSTAT. You can either create this user and then call the script SPCREATE.SQL as a user with SYSDBA privilege or run the script as a batch job in SQL*Plus, after first assigning the variables DEFAULT_TABLESPACE and TEMPORARY_TABLESPACE.
In either case, the SPCREATE.SQL script calls the SPCUSR.SQL, SPCTAB.SQL, and SPCPKG.SQL scripts and saves the results of these scripts in their corresponding .LIS files.