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,

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-l
Received on Sun Jul 11 2010 - 13:58:01 CDT

Original text of this message