OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » Verify statspack (Oracle 9.2.0.8.0,windows)

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

Verify statspack [message #555792]

Tue, 29 May 2012 00:55

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Hi,
To install statspack in oracle database , we perform the following
Connect as a user with SYSDBA privilege and run the following.

SQL>  @?/rdbms/admin/spcreate

To take a snapshot,login to SQL*Plus as the PERFSTAT user and run the procedure STATSPACK.SNAP.

My question is how to verify statspack is installed in my database before taking a snapshot by logging as PERFSTAT user?

Thank you

Report message to a moderator

Re: Verify statspack [message #555797 is a reply to message #555792]

Tue, 29 May 2012 01:05

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Check if the tables are there?
Or just execute spcreate then you are sure they are.

Regards
Michel

Report message to a moderator

Re: Verify statspack [message #555801 is a reply to message #555797]

Tue, 29 May 2012 01:32

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Michel,

Quote:

Check if the tables are there?

Can you tell me what tables i need to check?
Quote:

execute spcreate then you are sure they are.

Can you complete the above sentence ?

Regards

Report message to a moderator

Re: Verify statspack [message #555803 is a reply to message #555801]

Tue, 29 May 2012 01:47

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Can you tell me what tables i need to check?

Can you read spcreate.sql file?

Quote:

Can you complete the above sentence ?

...they are there.
Or better, execute spreport.sql, it will tell you.

Regards
Michel

Report message to a moderator

Re: Verify statspack [message #555814 is a reply to message #555803]

Tue, 29 May 2012 02:41

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Michel
I tried the below steps but session disappear after entering the password for perfstat.

SQL> @?/rdbms/admin/spcreate

Choose the PERFSTAT user's password
-----------------------------------
Not specifying a password will result in the installation FAILING

Enter value for perfstat_password:

Note: - i know i have given wrong password.

My question is if the above steps are correct to generate statspack report ,then why are we using below steps.
Quote:

The simplest interactive way to take a snapshot is to login to SQL*Plus as the PERFSTAT user and run the procedure STATSPACK.SNAP. For example:

SQL> CONNECT perfstat/my_perfstat_password
SQL> EXECUTE statspack.snap;

Regards,
Jack

Report message to a moderator

Re: Verify statspack [message #555817 is a reply to message #555814]

Tue, 29 May 2012 02:47

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

My question is if the above steps are correct to generate statspack report

No, this is to create the statspack objects. To create a report use... spreport.

Quote:

Quote:

Quote what? Once more ALWAYS provide a link or a clear reference to what you quote.

Quote:

then why are we using below steps

To create a snapshot.

You lack the basics about staspack.
Please read spdoc.txt.

Regards
Michel

Report message to a moderator

Previous Topic:	Privilege to run explain plan
Next Topic:	Query optimize

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Sep 13 20:15:43 CDT 2025