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%'






No comments:

Post a Comment

Key Differences & 19c Best Practices (AMM and ASMM)

Key Differences between  AMM and ASMM  & 19c Best Practices AMM (Automatic Memory Management) -  (MEMORY_TARGET): How it works: Oracle a...