$ORACLE_HOME/sqlplus/admin/plustrce.sql

plustrce.sql creates a role (named plustrace) which grants access to the three dynamic performance views v$sesstat, v$statname and v$mystat.

This role is used by the SQL*Plus command set autotrace … statistics.

After executing plustrace.sql, the DBA should grant plustrace to each user which needs to run the set autotrace command in SQL*Plus.