Re: Odd blocking (or massively latent) issue - even with EXPLAIN

On Mon, 2012-07-23 at 09:53 -0400, Andrew Dunstan wrote:
> On 07/23/2012 04:41 AM, Jim Vanns wrote:
> > We're seeing SELECT statements and even EXPLAIN (no ANAYLZE)
> > statements hang indefinitely until *something* (we don't know what)
> > releases some kind of resource or no longer becomes a massive bottle
> > neck. These are the symptoms.
>
> I have seen this sort of behaviour on systems with massive catalogs
> (millions of tables and indexes). Could that be your problem?

Possibly. I'm not familiar with the catalogs. I'll look into that.

Thanks,

Jim

>
> cheers
>
> andrew
>

--
Jim Vanns
Systems Programmer
Framestore