Re: Fwd: 11gR2: More than thousand child cursors for an update
From: Martin Klier <usn_at_usn-it.de>
Date: Sun, 11 Jul 2010 20:58:01 +0200
Message-ID: <4C3A1439.6020306_at_usn-it.de>
Hi Tanel,
Date: Sun, 11 Jul 2010 20:58:01 +0200
Message-ID: <4C3A1439.6020306_at_usn-it.de>
Hi Tanel,
thanks for your response. The child cursors are having all different
bind variable sets.
Is this a satisfactory answer for you?
Unfortunately I can't try to collect further information at the moment since I had to configure the optimizer feature enable parameter back to 10g for the sake of getting the plant work done.
Thanks
Martin
Tanel Poder schrieb:
> What does the V$SQL_SHARED_CURSOR say for all these child cursors?
-- Usn's IT Blog for Linux, Oracle, Asterisk http://www.usn-it.de -- http://www.freelists.org/webpage/oracle-lReceived on Sun Jul 11 2010 - 13:58:01 CDT