ablog

不器用で落着きのない技術者のメモ

HASH_VALUE から OLD_HASH_VALUE を求める

select snap_id, sql_id, hash_value, old_hash_value, plan_hash_value, cost
        from stats$sql_plan_usage
                where hash_value = 3805929877;

参考

Secret ORACLE: Unleashing the Full Potential of the ORACLE DBMS by Leveraging Undocumented Features

Secret ORACLE: Unleashing the Full Potential of the ORACLE DBMS by Leveraging Undocumented Features

P.265