Under what circumstances will a cursor be listed in V$SQL_SHARED_CURSOR
but have all "N" for mismatches? I looked around in askTom and google,
but trying to find the right keywords is tricky. The documentation
states:
V$SQL_SHARED_CURSOR explains why a particular child cursor is not shared
with existing child cursors. Each column identifies a specific reason
why the cursor cannot be shared.
Clearly, I was foolish to take that literally. =) I found a couple
metalink notes that reference some older bugs, but they are all fixed in
our version.
Oracle 10.2.0.2
cursor_sharing = EXACT
TIA
charles schultz
oracle dba
aits - adsd
university of illinois
