"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:<b6ovcv$qgg$1$8300dec7_at_news.demon.co.uk>...
> Comments inline
>
>
> Do you have multiple children in v$sql for each statement ?
> When using proper bind variable techniques, I believe that
> if the maximum size of the bind variable changes significantly
> between callls, then a new child cursor has to be created and
> is therefore subject to a hard parse, and some programming tools
> set the maximum size to the actual size automatically. Is it
> possible that this might be related in some way to your problem -
> viz. using more memory that expected, therefore causing more
> reloads than expected.
This might explain why we have child cursors for sharable SQL that
Oracle support said should not have children while they were trying to
help us trace down what they acknowledged was a library cache space
management bug that was never resolved. And it makes me wonder if we
were locked into looking at the wrong area.
Received on Sun Apr 06 2003 - 12:27:52 CDT
