Home » RDBMS Server » Performance Tuning » Verify statspack (Oracle 9.2.0.8.0,windows)
Verify statspack [message #555792] Tue, 29 May 2012 00:55 Go to next message
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
Re: Verify statspack [message #555797 is a reply to message #555792] Tue, 29 May 2012 01:05 Go to previous messageGo to next message
Michel Cadot
Messages: 67946
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Check if the tables are there?
Or just execute spcreate then you are sure they are.

Regards
Michel
Re: Verify statspack [message #555801 is a reply to message #555797] Tue, 29 May 2012 01:32 Go to previous messageGo to next message
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
Re: Verify statspack [message #555803 is a reply to message #555801] Tue, 29 May 2012 01:47 Go to previous messageGo to next message
Michel Cadot
Messages: 67946
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Verify statspack [message #555814 is a reply to message #555803] Tue, 29 May 2012 02:41 Go to previous messageGo to next message
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
Re: Verify statspack [message #555817 is a reply to message #555814] Tue, 29 May 2012 02:47 Go to previous message
Michel Cadot
Messages: 67946
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Privilege to run explain plan
Next Topic: Query optimize
Goto Forum:
  


Current Time: Fri Sep 17 18:40:36 CDT 2021