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@xxxxxxxxxx>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. > -- //www.freelists.org/webpage/oracle-l