ITPUB

Aug 24, 2016 · Databases

Why Does a Single Oracle SQL Generate Multiple Child Cursors? Understanding Rolling Invalidation

During performance testing, an Oracle SQL using bind variables showed two child cursors with identical execution plans; the article explains this phenomenon by detailing Oracle’s rolling cursor invalidation mechanism, the role of the ROLL_INVALID_MISMATCH flag, and how to reproduce and observe it.