Permissions for Autotrace
If you want to run AutoTrace using Toad using a non sys or system user, give your user the following select privileges: grant select on v_$session to &traceuser.; grant select on v_$sesstat to &traceuser.; grant select on v_$statname to &traceuser.; Alternately you can run $ORACLE_HOME/sqlplus/admin/plustrce.sql…
