Re: Really strange performance issue

From: David Fitzjarrell <oratune_at_yahoo.com>
Date: Thu, 30 Oct 2014 07:56:15 -0700
Message-ID: <1414680975.90458.YahooMailNeo_at_web124704.mail.ne1.yahoo.com>

Any possibility of seeing a 10046 trace at level 12? The wait information might be quite enlightening.  

David Fitzjarrell

Principal author, "Oracle Exadata Survival Guide"

On Thursday, October 30, 2014 8:51 AM, Andrew Kerber <andrew.kerber_at_gmail.com> wrote:  

I'll have to see if I can remove identifying information, but there is really nothing special about it, basically a two table join with a couple of embedded selects to get a date range. The plan is the same in both cases.

Sent from my iPad

> On Oct 30, 2014, at 9:42 AM, Howard Latham <howard.latham_at_gmail.com> wrote:
>
> Any chance of seeing the Query please?

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

Received on Thu Oct 30 2014 - 15:56:15 CET