OraRep Documentation

Though the documentation is included in the distributed package, you may want to have a look into before downloading. So here's your chance:

Open Documentation

One more hint: If you want to run reports using a user other than SYS or SYSTEM, you must grant a bunch of permissions to that user. The easiest way to get a list what is appropriate for your version of Oracle, is to use the permissions of the PERFSTAT user (the one collecting statistic information for STATSPACK). Say you have an Oracle user named ORAREP who should run the report, you can create a proper SQL script setting the permissions this way:

grep -i grant $ORACLE_HOME/rdbms/admin/spcusr.sql |sed 's/PERFSTAT/ORAREP/' >permissions.sql