Setting Up Autotrace
Connect to SQL*Plus with SYSDBA privileges and run the following script:
$ORACLE_HOME/sqlplus/admin/plustrce.sql
This should then be followed by:
GRANT plustrace TO PUBLIC;
Again, this could be refined to granting the role to individual user accounts rather than the public.
