OraFAQ Forum: Server Administration » information regarding Stats pack

Home » RDBMS Server » Server Administration » information regarding Stats pack

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

information regarding Stats pack [message #192891]

Thu, 14 September 2006 02:16

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

Report message to a moderator

Re: information regarding Stats pack [message #192920 is a reply to message #192891]

Thu, 14 September 2006 04:16

ThomasG
Messages: 3212
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

Report message to a moderator

Re: information regarding Stats pack [message #192951 is a reply to message #192891]

Thu, 14 September 2006 06:30

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

Report message to a moderator

Re: information regarding Stats pack [message #192955 is a reply to message #192951]

Thu, 14 September 2006 06:38

Mahesh Rajendran
Messages: 10707
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

Report message to a moderator

Previous Topic:	Connect to another server and execute file
Next Topic:	public synonyms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:43:32 CDT 2024