Oracle StatsPack
Version 12.1.0.2

General Information
Library Note Morgan's Library Page Header
The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.2 to 12.2.0.1. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Have you viewed the Library's main Table of Contents? If not ... [Click Here] ... scroll down the page and you will find links to the largest collection of Oracle Database demos on the net.
Purpose StatsPack is ...
Primary StatsPack Creation Scripts
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
   
Dependencies
     
     
     
 
CDB$ROOT
   
 
   
 
   
 
 
PDBDEV
   
 
  C:\Users\oracle>sqlplus sys@pdbdev as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Sun Oct 11 17:50:43 2015

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Enter password:

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

 
   
   
   

Related Topics
ASH Report
Automated Workload Repository
AWR Report
What's New In 12cR1
What's New In 12cR2

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-2017 Daniel A. Morgan All Rights Reserved