Adaptive Cursor Sharing

since 11g

adaptive cursor sharing can only lead to an improved plan after the SQL statement has tanked at least once

is_bind_sensitive
is_bind_aware

Adaptive Execution Plans