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

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-l