Is there a way I can look at the execution plan for a specific query in Oracle?

I would appreciate if you can point me to any relevant resources.  Thanks.
Who is Participating?
sdstuberConnect With a Mentor Commented:
explain plan for (your query);

for example..

explain plan for select * from user_tables;


select * from table(dbms_xplan.display);

for more information about the dbms_xplan package and options on the display function,  see the oracle docs
thomaszhwangAuthor Commented:
I will test this tomorrow.  It has been too late today...  Thanks though.
PortletPaulConnect With a Mentor Commented:
Here's an Oracle whitepaper (May 2011) on explain plans I found very useful:
The Oracle Optimizer Explain the Explain Plan

Not sure if they have a newer version - but it's still relevant.

Note there is quite a difference between 'explain plans' and 'execution plans' from other products e.g. SQL Server uses %ages, but Oracle explain plans do not and the metrics presented are quite different to .sqlplan details.
thomaszhwangAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.