Home » RDBMS Server » Server Administration » information regarding Stats pack
information regarding Stats pack [message #192891] Thu, 14 September 2006 02:16 Go to next message
Messages: 7
Registered: August 2005
Location: india
Junior Member
Please provide the details of Stats pack. means how to generate it, how to read it & on what parameters should we concentrate?

Thanks in advance
Re: information regarding Stats pack [message #192920 is a reply to message #192891] Thu, 14 September 2006 04:16 Go to previous messageGo to next message
Messages: 3202
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
No, I will not copy-and-paste the complete available documentation here.

For example :

Re: information regarding Stats pack [message #192951 is a reply to message #192891] Thu, 14 September 2006 06:30 Go to previous messageGo to next message
Messages: 52
Registered: August 2006
Location: India

Statspack is a set of performance monitoring and reporting utilities provided by Oracle from Oracle8i and above. Statspack provides improved BSTAT/ESTAT functionality, though the old BSTAT/ESTAT scripts are still available. For more information about STATSPACK, read the documentation in file


Install Statspack:

cd $ORACLE_HOME/rdbms/admin

sqlplus "/ as sysdba" @spdrop.sql -- Install Statspack
sqlplus "/ as sysdba" @spcreate.sql -- Enter tablespace names when prompted

Use Statspack:

sqlplus perfstat/perfstat

exec statspack.snap; -- Take a performance snapshots
exec statspack.snap;

-- Get a list of snapshots


@spreport.sql -- Enter two snapshot id's for difference report

Other Statspack Scripts:

sppurge.sql - Purge a range of Snapshot Id's between the specified begin and end Snap Id's
spauto.sql - Schedule a dbms_job to automate the collection of STATPACK statistics
spcreate.sql - Installs the STATSPACK user, tables and package on a database (Run as SYS).
spdrop.sql - Deinstall STATSPACK from database (Run as SYS)
sppurge.sql - Delete a range of Snapshot Id's from the database
spreport.sql - Report on differences between values recorded in two snapshots
sptrunc.sql - Truncates all data in Statspack tables


Mohan Reddy G

Re: information regarding Stats pack [message #192955 is a reply to message #192951] Thu, 14 September 2006 06:38 Go to previous message
Mahesh Rajendran
Messages: 10673
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
We have warned you twice.
Do not COPY others work.
Previous Topic: Connect to another server and execute file
Next Topic: public synonyms
Goto Forum:

Current Time: Wed Jul 26 15:55:00 CDT 2017

Total time taken to generate the page: 0.14139 seconds