Re: Fwd: 11gR2: More than thousand child cursors for an update

From: Tanel Poder <tanel_at_poderc.com>
Date: Mon, 12 Jul 2010 23:37:04 +0800
Message-ID: <AANLkTinHDxvW6dQmBJPJsJhlS5i3mudKhlpY1hHSmaLv_at_mail.gmail.com>

So, to stop guessing, what does V$SQL_SHARED_CURSOR say? (it may not show a reason at all, if hitting some bug, but that's the first thing to check).

On Mon, Jul 12, 2010 at 11:13 PM, Martin Klier <usn_at_usn-it.de> wrote:

> Yes, I agree.
>
> At the moment, the situation is:
> - the issue does occur with optimizer features enable 10gR2 and 11gR2 as
> well
> - flushing the shared pool on a regular (minutely) basis
> - the crucial level was 300 children under load, and about 1000 cursors
>

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

Received on Mon Jul 12 2010 - 10:37:04 CDT