-
I am trying to trace a statement after passing in parameters. How can I do that with SQL Plus?
Thanks,
Kim
-
From a SQL prompt type
set autotrace on
-
I set Autotrace on and got the following error
Unable to verify PLAN_TABLE format or existence
Error enabling EXPLAIN report
Cannot find the Session Identifier. Check PLUSTRACE role is enabled
Error enabling STATISTICS report
-
Run script utlxplan.sql, ususaly in directory <ORACLE_HOME>\rdbms\admin.
From SQL propt type: set autotrace on explain
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|