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
vandana173
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
Vandana
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
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
No, I will not copy-and-paste the complete available documentation here.

For example :

http://www.akadia.com/services/ora_statspack_survival_guide.html
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
goudelly
Messages: 52
Registered: August 2006
Location: India
Member

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

$ORACLE_HOME/rdbms/admin/spdoc.txt.

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

select SNAP_ID, SNAP_TIME from STATS$SNAPSHOT;


@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


Thanks,

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: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
@goudelly
We have warned you twice.
Do not COPY others work.
http://www.orafaq.com/faqdbapf.htm#STATSPACK
Previous Topic: Connect to another server and execute file
Next Topic: public synonyms
Goto Forum:
  


Current Time: Sat Dec 10 02:49:49 CST 2016

Total time taken to generate the page: 0.05104 seconds