error when running STATSPACK

[sambavan]

Make sure the system parameter TIMED_STATISTICS=TRUE and did you gather the stats? Once after you install the statspack, you have to gather some stats. Once this was completed, you run the stats report there you will have to specify the starting and ending snap numbers to generate the stats report.

       sqlplus perfstat@instance_name
       SQL> execute statspack.snap(i_snap_level=>10, i_modify_parameter=> 'true');

Execute the above code a few times and then try generating your report.

Hope this will help.

Sam