RE: script to see explain plan

That script looks good to display execution plan of any arbitrary SQL
that's already in the shared pool.

If you're working on/tuning a query, you could also do:
explain plan for
<your query goes here>

And then do:
select * from table(dbms_xplan.display);
 

There is also autotrace, TkProf, etc.  There are lots of ways to get an
execution plan.

If I recall correctly, in 10g, dbms_xplan is enhanced, and you can use
it to display any arbitrary SQL's execution plan...you don't need that
script anymore.

Hope that helps,

-Mark


--
Mark J. Bobak
Senior Oracle Architect
ProQuest Information & Learning

For a successful technology, reality must take precedence over public
relations, for Nature cannot be fooled.  --Richard P. Feynman, 1918-1988


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Wojciech Skrzynecki
Sent: Thursday, October 05, 2006 5:04 PM
To: oracle-l
Subject: script to see explain plan

Hello Everybody


I would like ask you to about explain plan. I am looking for the best
script to see explain plan. I know that it is possible to see explain
plan for active session of other users. I use script from metalink
Note:260942.1. Maybe you use better scripts to see explain plan.


--
Wojciech Skrzynecki
Database Administrator
--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l

Other related posts: