invalidation

Oracle 12cR2: exchange partition deferred invalidation

By Franck Pachot . In a previous post I introduced the new 12cR2 feature where some DDL operations can use the same rolling invalidation than what is done with dbms_stats. On tables, DDL deferred invalidation is(…)

Oracle 12cR2: IS_ROLLING_INVALID in V$SQL

By Franck Pachot . In a previous post I published a test case to show when a cursor is not shared anymore after a rolling invalidation. Basically the dbms_stats marks the cursor as 'rolling invalid' and(…)