Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: What is the best method to collect EXPLAIN PLAN for a lot of SQL statement
It does. Mea Culpa
Niall
DA Morgan wrote:
> Niall Litchfield wrote:
>
> > <dominica_at_gmail.com> wrote in message
> > news:1115256129.754966.230680_at_o13g2000cwo.googlegroups.com...
> > In 9i there is a new view V$SQLPLAN which will contain the plans
for your
> > statements. I'd recommend that you use that for the upgraded db.
> >
> > For the 8i part of it I guess you'd need to write some sort of
script to
> > populate plan_table with tyhe plan for each statement (generating a
new
> > statement id for each).
> >
> > I'd suggest not bothering with comparing plans until you have
identified
> > those statements that perform poorly after the upgrade.
> >
> > HTH
>
> In 10g that is v$sql_plan. I presume it also has the underscore
> in 9i.
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace 'x' with 'u' to respond)
Received on Mon May 09 2005 - 08:56:31 CDT
![]() |
![]() |