Re: set Autotrace on error

From: NeilC <neilc-olops_at_nospambtinternet.com>
Date: Thu, 23 Dec 1999 08:52:17 +0000
Message-ID: <3861E2C1.B605E8FD@nospambtinternet.com>

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