Thursday, June 3, 2021

Difference between hash_value and plan_hash_value in oracle

 hash_value and plan_hash_value



select sql_text,sql_id,hash_value,plan_hash_value from v$sql where sql_text like '%last_name%'






at
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Oracle 26 ai database free

 https://www.oracle.com/in/database/26ai/ Oracle 26 ai release  Oracle AI Database Free Want to get hands-on with Oracle AI Database 26ai—ab...