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.
Received on Sat Mar 20 2004 - 18:06:16 CST
