In Addition to previous note, following grants needed on PERFSTAT user.

/* System privileges */

grant create session to PERFSTAT;

grant alter session to PERFSTAT;

grant create table to PERFSTAT;

grant create procedure to PERFSTAT;

grant create sequence to PERFSTAT;

grant create public synonym to PERFSTAT;

grant drop public synonym to PERFSTAT;

/* Select privileges on STATSPACK created views */

grant select on X_$KCBFWAIT to PERFSTAT;

grant select on X_$KSPPSV to PERFSTAT;

grant select on X_$KSPPI to PERFSTAT;

grant select on X_$KSQST to PERFSTAT;

grant select on V$FILESTATXS to PERFSTAT;

grant select on V$TEMPSTATXS to PERFSTAT;

grant select on V$SQLXS to PERFSTAT;

/* Roles */

grant SELECT_CATALOG_ROLE to PERFSTAT;

/* Select privs for catalog objects – ROLES disabled in PL/SQL packages */

grant select on V_$PARAMETER to PERFSTAT;

grant select on V_$SYSTEM_PARAMETER to PERFSTAT;

grant select on V_$DATABASE to PERFSTAT;

grant select on V_$INSTANCE to PERFSTAT;

grant select on V_$LIBRARYCACHE to PERFSTAT;

grant select on V_$LATCH to PERFSTAT;

grant select on V_$LATCH_MISSES to PERFSTAT;

grant select on V_$LATCH_CHILDREN to PERFSTAT;

grant select on V_$LATCH_PARENT to PERFSTAT;

grant select on V_$ROLLSTAT to PERFSTAT;

grant select on V_$ROWCACHE to PERFSTAT;

grant select on V_$SGA to PERFSTAT;

grant select on V_$BUFFER_POOL to PERFSTAT;

grant select on V_$SGASTAT to PERFSTAT;

grant select on V_$SYSTEM_EVENT to PERFSTAT;

grant select on V_$SESSION to PERFSTAT;

grant select on V_$SESSION_EVENT to PERFSTAT;

grant select on V_$SYSSTAT to PERFSTAT;

grant select on V_$WAITSTAT to PERFSTAT;

grant select on V_$SQLAREA to PERFSTAT;

grant select on V_$SQL to PERFSTAT;

grant select on V_$SQLTEXT to PERFSTAT;

grant select on V_$SESSTAT to PERFSTAT;

grant select on V_$BUFFER_POOL_STATISTICS to PERFSTAT;

/* Packages */

grant execute on DBMS_SHARED_POOL to PERFSTAT;

grant execute on DBMS_JOB to PERFSTAT