RE: script to see explain plan
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <wojciech.skrzynecki@xxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 5 Oct 2006 17:12:17 -0400
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
