Adaptive Cursor Sharing
An Oracle mechanism that can maintain different suitable child cursors for the same bind-based SQL when observed bind-value selectivity makes one shared plan inadequate.
A single shareable cursor is not always efficient for every bind value. Adaptive Cursor Sharing observes whether execution behavior is bind-sensitive and can create bind-aware child cursors when different selectivity ranges justify different plans.
It does not mean “one new plan per value”; the optimizer adjusts the boundary of cursor sharing from observed cardinality behavior. Together with bind peeking, it explains why identical SQL text can legitimately execute with different plans. See Oracle SQL performance for the larger context.