Home » RDBMS Server » Performance Tuning » How to generate statspack report for a patricular user in my TEST database ?
How to generate statspack report for a patricular user in my TEST database ? [message #233920] Sat, 28 April 2007 04:28 Go to next message
kesevan
Messages: 17
Registered: April 2007
Location: MUMABI
Junior Member

Dear Sir, 
I have the following doubt....

iam in a position to compare my TEST database and PRODUCTION database. For PRODUCTION database i have got the statspack reprot to analyze the performance...but for TEST database i don't have statspack report... now i need to generate this report in TEST database. i don't have SYSDBA privilege in TEST database....and in TEST database... i need to analyze the performance of our user : WMSDBA...

For this user : WMSDBA in my TEST database, i have the following privileges: 


SQL> show user
USER is "WMSDBA"
SQL> select * from user_sys_privs;

USERNAME                       PRIVILEGE                                ADM
------------------------------ ---------------------------------------- ---
WMSDBA                         CREATE SYNONYM                           NO
WMSDBA                         CREATE ANY SYNONYM                       NO
WMSDBA                         CREATE DATABASE LINK                     NO
WMSDBA                         UNLIMITED TABLESPACE                     NO

SQL> select * from user_role_privs;

USERNAME                       GRANTED_ROLE                   ADM DEF OS_
------------------------------ ------------------------------ --- --- ---
WMSDBA                         DBA                            NO  YES NO
WMSDBA                         PLUSTRACE                      YES YES NO
WMSDBA                         WMSDBA_ROLE                    YES YES NO

I need to generate the statspack report to analyze the performance of this patricular USER ( WMSDBA )  in my TEST database.  Please clarify me, after connecting this user, can i generate STATSPACK REPORT ? If i can able to generate, please guide me how to do the same ?

But, I know how to generate the statspack report. 

Thank you, 
Re: How to generate statspack report for a patricular user in my TEST database ? [message #233930 is a reply to message #233920] Sat, 28 April 2007 05:10 Go to previous message
Brayan
Messages: 315
Registered: June 2002
Senior Member
Hi,

This might help you.

Brayan.
Previous Topic: Unable to generate explain plan in production database
Next Topic: Some Suggestions
Goto Forum:
  


Current Time: Sun Dec 04 00:32:56 CST 2016

Total time taken to generate the page: 0.08571 seconds