Re: Inability to reliably monitor long-running parallel queries

From: Adric Norris <landstander668_at_gmail.com>
Date: Fri, 2 Nov 2012 14:14:44 -0500
Message-ID: <CAJueESocwBdc6Jhps-YdOjkt9F=PxHEOnjXQ7KMNZV=1+6ojBw_at_mail.gmail.com>

I've noticed this as well, although I hadn't had an opportunity to troubleshoot this issue. I'm glad that you've cleared up the mystery, but definitely share your disappointment with the "not a bug" designation. The feature would be *far* more useful without this limitation. On Fri, Nov 2, 2012 at 11:36 AM, Tornblad, John <JTornblad_at_emdeon.com>wrote:

> It turns out that the issue for a parallel query is MMON is watching
> *all* of the parallel servers / slaves and if *any* are idle for more
> than an internally hard-coded 30 minutes... the finger of death is
> applied and the monitoring of the query is terminated... even though
> other parallel servers are active on the same query. I am not sure if
> the query coordinator is included, it seems very likely the QC is idle
> for big queries for more than 30 minutes (easily).
>
> Just wondering if anyone else has run into this issue, I cannot be the
> only customer who has noticed this. Despite "not a bug" declarations it
> seems like this is a bug / misfeature / unwelcome aggressiveness from
> MMON.
>

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

Received on Fri Nov 02 2012 - 20:14:44 CET