Requires Free Membership to View
One way to do it is to query V$SQL_PLAN, which contains the execution
plan for each cursor in the SQL cache.
This was first published in October 2004
Writing script to automatically read last query without using AUTOTRACE
How can I write a script to automatically read the last query I
submitted and generate the execution plan for the query without using
the AUTOTRACE tool or EXPLAIN PLAIN command?
One way to do it is to query V$SQL_PLAN, which contains the execution
plan for each cursor in the SQL cache.
One way to do it is to query V$SQL_PLAN, which contains the execution
plan for each cursor in the SQL cache.
Join the conversationComment
Share
Comments
Results
Contribute to the conversation