OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » Statpack report

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

Statpack report [message #145744]

Sat, 05 November 2005 13:50

rc_ashish
Messages: 39
Registered: June 2005
Location: mumbai

Member

Dear Friends,

Can you give me steps for generating statpack report?

I am awaiting for reply...

Thanx in Advance....

Ashish

Report message to a moderator

Re: Statpack report [message #145747 is a reply to message #145744]

Sat, 05 November 2005 17:14

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/statspac.htm#34837

Report message to a moderator

Re: Statpack report [message #145809 is a reply to message #145744]

Sun, 06 November 2005 22:36

deeptimadan
Messages: 17
Registered: October 2005

Junior Member

hi

Below are the steps to generate a STATSPACK REPORT
Firstly set timed_statistics on by command
->alter system set timed_statistics=true
NOw
->Create tablespace statspack(at least 64 MB)
->Run spcreate.sql as sysdba
->Connect perfstat/perfstat
->execute statspack.snap
Then after 15 more mins.
->execute statspack.snap
Now ->select name,snap_id from stats$snapshot,v$database
Now Create report by
Sql>@ /usr../oracle/rdbms/admin/spreport.sql
-> enter both snap-Ids
and u will be having a report

Regards

Report message to a moderator

Re: Statpack report [message #145824 is a reply to message #145809]

Mon, 07 November 2005 01:33

Frank
Messages: 7901
Registered: March 2000

Senior Member

I liked Mahesh's answer better. It is nonsense to install statspack and create (manually!) snaps without reading the docs.

hth

Report message to a moderator

Re: Statpack report [message #146284 is a reply to message #145744]

Wed, 09 November 2005 13:51

rc_ashish
Messages: 39
Registered: June 2005
Location: mumbai

Member

Dear All,

Thanks for this.

Ashish

Report message to a moderator

Re: Statpack report [message #161996 is a reply to message #145744]

Wed, 08 March 2006 02:33

rzmni
Messages: 8
Registered: May 2005

Junior Member

i already run using mahesh solution..but the problem is i want to look that file..n i search but no files found..help me!!...im using the default name...

Report message to a moderator

Re: Statpack report [message #162042 is a reply to message #161996]

Wed, 08 March 2006 06:21

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>i already run using mahesh solution..but the problem is i want to look that file..n i search but no files found..help me!!...im using the default name..
Well, I swear, it is not my solution. It is Oracle's own solution. Smile

What files are you talking about here?

Report message to a moderator

Previous Topic:	please help me ->cpu id 0
Next Topic:	Please tune this Query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Mar 07 20:02:00 CST 2026