Etravels
asked on
SEEING RESULTS OF EXPLAIN PLAN? CAN'T SEE IT
> in sqlplus environment, I typed: set autotrace on, and got the
following
> error:
> SP2-0613: Unable to verify PLAN_TABLE format or existence
> SP2-0611: Error enabling EXPLAIN report
> SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is
> enabled
> SP2-0611: Error enabling STATISTICS report
i DO THE FOLLOWING, WHICH WORKS
Run utlxplan.sql in the schema you want to autotrace (creates the
table).
Run plustrce.sql as sys (creates the role).
grant plustrace to the schema you want to autotrace.
THEN i GO BACK & TYPE THE FOLLOWING:
SET LINES 8000
SET AUTOTRACE ON
ANALYZE TABLE ACTION_SET COMPUTE STATISTICS;
SQL >TABLE ANAYLZED
wHER IS THE ' THE 'EXPLAIN' PLAN ' AND ALL IS SEE IS 'TABLE
HOW CAN I SEE RESULTS?
regards
following
> error:
> SP2-0613: Unable to verify PLAN_TABLE format or existence
> SP2-0611: Error enabling EXPLAIN report
> SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is
> enabled
> SP2-0611: Error enabling STATISTICS report
i DO THE FOLLOWING, WHICH WORKS
Run utlxplan.sql in the schema you want to autotrace (creates the
table).
Run plustrce.sql as sys (creates the role).
grant plustrace to the schema you want to autotrace.
THEN i GO BACK & TYPE THE FOLLOWING:
SET LINES 8000
SET AUTOTRACE ON
ANALYZE TABLE ACTION_SET COMPUTE STATISTICS;
SQL >TABLE ANAYLZED
wHER IS THE ' THE 'EXPLAIN' PLAN ' AND ALL IS SEE IS 'TABLE
HOW CAN I SEE RESULTS?
regards
jwittenm
from the $ORACLE_HOME/rdbms/admin directory, log into sqlplus as the user you want to do the explains and run '@utlxplan'. This will create the explain_plan table for user sys.
Sorry, didn't finish reading. Please ignore!
I'll take another look at it.
I'll take another look at it.
At this point, I'm not sure what the issue is. Are you still not able to set autotrace on? Are you not able to see the statistics?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.