Search This Blog

Q: Would it have any impact like holding library cache latches for longer time to search for appropriate child cursor?

A: Any additional overhead in matching a cursor is always a concern, and we strive to minimize the impact. There is of course some increase in the code path to match a bind-aware cursor, since it requires more intelligent checks. This feature should not, however, impact cursors which are not yet marked bind-aware.