Alejandro Vargas' Blog

  • January 11, 2007

Many Child Cursors with on Linux 32 bits and Windows

Alejandro Vargas
Technical Leader, ACS Global Delivery, Infrastructure & BigData

The problem reproduces on Oracle Server Patch Set on the 32bit Windows and 32bit Linux platforms only.

Please review Note
403616.1 "Many Child Cursors create in on Windows and Linux"


  is already available for Linux x86 on Metalink. It is convenient to apply this patch immediately after Patch Set on any Linux x86 server.

The problem will reproduce if bind variables used on the same sql statement have different lenghts.

This behaviour is the well known  reason for not sharing identical sql statements, that lead to bind variable mismatch, the difference is that in previous versions an statement that would create 5 child cursors will create 16 on The problem is more severe for differing bind lengths and

larger numbers of binds.

Join the discussion

Comments ( 1 )
  • Philippe Thursday, January 11, 2007
    hi alejandro,
    have a look at this blog ...
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.