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,