Re: Re: plan_table performance

From: K R <kp0773_at_gmail.com>
Date: Thu, 17 Dec 2009 09:45:04 -0800
Message-ID: <39a33df90912170945n1054f37cwcbf33e6758baaaee_at_mail.gmail.com>

this is on 10.2.0.4 running in Redhat Linux on a RAC 2 node cluster using ASM On Thu, Dec 17, 2009 at 9:41 AM, Daniel W. Fink <daniel.fink_at_optimaldba.com>wrote:

> What version of the database? This is critical information.
>
> Each release has it's own changes, bugs, issues, etc. There is little to be
> gained without knowing the release.
>
>
> Daniel Fink
>
> OptimalDBA http://www.optimaldba.com
> Oracle Blog http://optimaldba.blogspot.com
>
> Lost Data? http://www.ora600.be/
> ------- Original Message -------
> On 12/17/2009 5:18 PM K R wrote:
> my normal way is to do the explain plan using toad . but even I tested
> doing the explain plan for <stmt> in sqlplus and both taking long time.I
> am not using dbms_xplain
> On Thu, Dec 17, 2009 at 8:42 AM, Daniel W. Fink <
> daniel.fink_at_optimaldba.com> wrote:
> What version of Oracle are you using? The plan_table changed from a
> 'regular' table to a global temporary table in 10g.
>
> Are you using the explain plan for statement or dbms_xplan?
>
> Daniel Fink
>
> OptimalDBA http://www.optimaldba.com
> Oracle Blog http://optimaldba.blogspot.com
>
> Lost Data? http://www.ora600.be/
>
>
> ------- Original Message ------- Date: 12/17/2009 3:25 PM From: K R <
> kp0773_at_gmail.com>
> To:Oracle-L_at_freelists.org <To%3AOracle-L_at_freelists.org> Subject:
> plan_table performance
>
> All,In one of the database when I run the explain plan it takes a while
> before I get the plan output . so I created a index on statement_id . but
> still no luck.Anyone have any idea on how to resolve this . Appreciate any
> suggestions!TIAKar
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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

Received on Thu Dec 17 2009 - 11:45:04 CST