tkprof problem

From: Frank Langelage <frank_at_lafr.de>
Date: Fri, 19 Mar 2004 20:24:42 +0100
Message-ID: <c3fhdq$26l8e6$1@ID-48907.news.uni-berlin.de>

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. Received on Fri Mar 19 2004 - 13:24:42 CST