Description |
Script |
Create Script: calls spcusr.sql, spectab.sql, and spcpkg.sql |
?/rdbms/admin/sbcreate.sql |
Create User and Required Privileges |
?/rdbms/admin/spcusr.sql |
Create Required Tables |
?/rdbms/admin/spctab.sql |
Creates Statistics Package |
?/rdbms/admin/sbcpkg.sql |
Validate Installation |
conn perfstat/perfstat@orabase |
Automates Statistics Collection |
?/rdbms/admin/spauto.sql |
Server Performance AWR RAC Report |
?/rdbms/admin/spawrrac.sql |
Purges a Range of Snapshots |
?/rdbms/admin/sppurge.sql |
Report Configuration |
?/rdbms/admin/sprepcon.sql |
Default StatsPack Report |
?/rdbms/admin/spreport.sql (calls sprepins.sql) |
Snapshot Instance Difference Report |
?/rdbms/admin/sprepins.sql |
Standard StatsPack Report |
?/rdbms/admin/sprepsql.sql (calls sprsqins.sql) |
Resource Usage, SQL Text & Plans Report |
?/rdbms/admin/sprsqins.sql |
Truncates the StatsPack Tables |
?/rdbms/admin/sptrunc.sql |
Drops the user, tables, and package |
?/rdbms/admin/spdrop.sql |
Drops StatsPack Tables |
?/rdbms/admin/spdtab.sql |
Drops StatsPack User |
?/rdbms/admin/spdusr.sql |