| Primary StatsPack Creation Scripts |
| Master Create Script |
SQL> @?\rdbms\admin\sbcreate.sql (calls spcusr.sql, spectab.sql, and spcpkg.sql)
-- be sure to record password for PERFSTAT user |
| Create User and Required Privileges |
SQL> @?/rdbms/admin/spcusr.sql |
| Create Required Tables |
SQL> @?/rdbms/admin/spctab.sql |
| Creates Statistics Package |
SQL> @?\rdbms\admin\sbcpkg.sql |
| Validate Installation |
conn perfstat/perfstat@orabase |
| Automates Statistics Collection |
SQL> @?\rdbms\admin\spauto.sql |
| Server Performance AWR RAC Report |
SQL> @?\rdbms\admin\spawrrac.sql |
| Purges a Range of Snapshots |
SQL> @?/rdbms/admin/sppurge.sql |
| Report Configuration |
SQL> @?\rdbms\admin\sprepcon.sql |
| Default StatsPack Report |
SQL> @?\rdbms\admin\spreport.sql (calls sprepins.sql) |
| Snapshot Instance Difference Report |
SQL> @?\rdbms\admin\sprepins.sql |
| Standard StatsPack Report |
SQL> @?\rdbms\admin\sprepsql.sql (calls sprsqins.sql) |
| Resource Usage, SQL Text & Plans Report |
SQL> @?\rdbms\admin\sprsqins.sql |
| Truncates the StatsPack Tables |
SQL> @?\rdbms\admin\sptrunc.sql |
| Drops the user, tables, and package |
SQL> @?\rdbms\admin\spdrop.sql |
| Drops the Tables |
SQL> @?\rdbms\admin\spdtab.sql |
| Drops the User |
SQL> @?\rdbms\admin\spdusr.sql |
| |
| Standby StatsPack Creation Scripts |
| Driver Create Script |
SQL> @?/rdbms/admin/sbcreate.sql (calls sbcusr.sql, sbctab.sql, and sbaddins.sql) |
| Create User and Required Privileges |
SQL> @?/rdbms/admin/sbcusr.sql |
| Create Required Tables |
SQL> @?/rdbms/admin/sbctab.sql |
| Add a Standby Database to the Configuration |
SQL> @?/rdbms/admin/sbaddins.sql (calls sbcpkg.sql) |
| Create Standby Statistics Package |
SQL> @?/rdbms/admin/sbcpkg.sql |
| List Standby Instances |
SQL> @?/rdbms/admin/sblisins.sql |
| Report Creation |
SQL> @?/rdbms/admin/sbreport.sql (calls sbrepcon.sql and sbrepins.sql) |
| Return Report Configuration |
SQL> @?/rdbms/admin/sbrepcon.sql |
| Report Creation |
SQL> @?/rdbms/admin/sbrepins.sql |
| Purge a Set of Snapshots |
SQL> @?/rdbms/admin/sbpurge.sql |
| Remove Standby Instance |
SQL> @?/rdbms/admin/sbdelins.sql |
| Drops the User and Tables |
SQL> @?/rdbms/admin/sbdrop.sql (calls sbdtab.sql and sbdusr.sql) |
| Drops the Tables |
SQL> @?/rdbms/admin/sbdtab.sql |
| Drops the User |
SQL> @?/rdbms/admin/sbdrop.sql |
