EXPLAIN PLAN disabled.
Hi,
We need to upload a tkprof result for our SR but it is needed to have an explain plan. The suggested syntax for this is:
tkprof 12345.trc 12345_et.prf explain=apps/apps print=20 sort='(prsela,exeela,fchela)'
however, the result we get has an error:
********************************************************************************
Error in CREATE TABLE of EXPLAIN PLAN table: APPS.prof
ORA-00922: missing or invalid option
parse error offset: 1038
EXPLAIN PLAN option disabled.
********************************************************************************
How can we properly generate a tkprof result with explain plan? We tried following solution from 'Tkprof Fails With Error In Create Table Of Explain Plan : Ora-922 [ID 293481.1]' but we still get the same error.
We need to upload a tkprof result for our SR but it is needed to have an explain plan. The suggested syntax for this is:
tkprof 12345.trc 12345_et.prf explain=apps/apps print=20 sort='(prsela,exeela,fchela)'
however, the result we get has an error:
********************************************************************************
Error in CREATE TABLE of EXPLAIN PLAN table: APPS.prof
ORA-00922: missing or invalid option
parse error offset: 1038
EXPLAIN PLAN option disabled.
********************************************************************************
How can we properly generate a tkprof result with explain plan? We tried following solution from 'Tkprof Fails With Error In Create Table Of Explain Plan : Ora-922 [ID 293481.1]' but we still get the same error.
Tagged:
0