Setting Up Autotrace

Posted 11 April, 2006 - 12:07

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.