Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: set Autotrace on error
Hi,
You need to run the script :- $ORACLE_HOME/rdbms/admin/utlxplan.sql to create the plan_table required to hold execution paths
You then need to run (as sys user) :-
$ORACLE_HOME/sqlplus/admin/plustrce.sql
to create the plustrace role and necessary grants to query relevant data
dictionary tables.
This role should then be granted to users using autotrace
HTH NeilC
Parvinder Singh wrote:
>
> Hi all
>
> When i execute set autotrace on this is the following error which i
> get ..what could be the reason ? can any one tell me ?
>
> SQL> set autotrace on;
> Unable to verify PLAN_TABLE format or existence
> Error enabling EXPLAIN report
> Cannot find the Session Identifier. Check PLUSTRACE role is enabled
> Error enabling STATISTICS report
>
> Regards
> ~Parvinder
> P.S : Also reply to parora_at_questone.com
>
Received on Thu Dec 23 1999 - 02:52:17 CST
![]() |
![]() |