Oracle Stats Pack
Version 11.2.0.3
 
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
 
 
Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2014 Daniel A. Morgan All Rights Reserved