Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: What is the best method to collect EXPLAIN PLAN for a lot of SQL statement

Re: What is the best method to collect EXPLAIN PLAN for a lot of SQL statement

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: 9 May 2005 06:56:31 -0700
Message-ID: <1115646991.284551.52870@z14g2000cwz.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US