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

  • From: Martin Klier <usn@xxxxxxxxx>
  • To: Tanel Poder <tanel@xxxxxxxxxx>
  • Date: Mon, 12 Jul 2010 18:45:49 +0200

Hi Tanel,

most of the cursors are BIND_MISMATCH=Y, sometimes OPTIMIZER_MISMATCH as
well (sometimes both).

Tanel Poder schrieb:
> 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).

Regards
Martin

-- 
Usn's IT Blog for Linux, Oracle, Asterisk
http://www.usn-it.de

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


Other related posts: