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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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 Received on Thu Oct 05 2006 - 16:12:17 CDT