RE: Fwd: 11gR2: More than thousand child cursors for an update
Date: Mon, 12 Jul 2010 07:49:39 +0200
Message-ID: <4814386347E41145AAE79139EAA3989810265B1CED_at_ws03-exch07.iconos.be>
Martin,
I am guessing here, but it could be caused by adaptive cursor sharing going crazy.
Following article gives you some information about adaptive cursor shareing and a couple of views which hold information about it: http://www.oracle.com/technology/pub/articles/oracle-database-11g-top-features/11g-sqlplanmanagement.html
Regards,
Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge_at_uptime.be
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Martin Klier
Sent: zondag 11 juli 2010 20:58
To: tanel_at_poderc.com
Cc: Oracle-L Freelists
Subject: Re: Fwd: 11gR2: More than thousand child cursors for an update
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 -- http://www.freelists.org/webpage/oracle-lReceived on Mon Jul 12 2010 - 00:49:39 CDT