AnaCDent wrote:
> Frank Langelage wrote:
>
>> executing tkprof on oracle tracefile with explain option set, gives
>> this error message in the output file:
>>
>> Error in CREATE TABLE of EXPLAIN PLAN table: JBOSS.prof$plan_table
>> ORA-00922: missing or invalid option
>>
>> parse error offset: 1050
>> EXPLAIN PLAN option disabled.
>>
>>
>> Command line was: tkprof ora10_ora_182.trc lafr.txt sys=no
>> explain=jboss/<password>.
>>
>> Sys is Oracle 10g on Sparc with Solaris 9.
>>
>>
>> What do I have to do to solve this problem ?
>>
>> If I use the table option with a permanent plan_table
>> (table=jboss.plan_table) I get the wanted execution plans in the
>> output of tkprof.
>
>
> Does schema JBOSS have a 10g compliant version of the PLAN_TABLE?
> Each release has a SQL script to create the PLAN_TABLE for any user who
> needs one.
>
Yes, jboss' permanent plan_table was created with the utlxplan.sql from
10g. As I wrote, if I use this table, the execution plan is there.
Received on Sun Mar 21 2004 - 04:17:27 CST
