Re: gather_plan_stats hint

From: Carlos Sierra <carlos.sierra.usa_at_gmail.com>
Date: Thu, 14 May 2015 07:44:01 -0400
Message-Id: <0CA8E6B4-F8A8-4982-99AA-FADE8C613ED6_at_gmail.com>

You may want to use SQLd360 or SQLTXPLAIN and expedite your investigation.

Sent from my iPhone

> On May 13, 2015, at 23:01, Orlando L <oralrnr_at_gmail.com> wrote:
>
> All,
>
> We have a SQL performing badly in prod intermittently in 11g. When it runs ok it finishes fine in seconds. When it is bad it does not finish even after 30/40 mins or even hours.
>
> I have to find out what is going on, so I used the gather_plan_stats hint, but I dont see a problem in the estimate vs actual when it runs good. However, I am not able to see the same thing when the query is slow or hangs. How do I see those values for such cases. TIA.
>
> Orlando.
>

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

Received on Thu May 14 2015 - 13:44:01 CEST