I know how to find the hash_value for the corresponding sql_text
Can anyone define what is hash_value. I already referred documentation and serched this forum also. But I could not find out.
HASH_VALUE - The Hash Value of the statement in the library cache.
When a SQL Statement is issues against the DB, the statement is passed through a hash procedure. Oracle uses this hash value to search the shared_pool for the already parsed statement.
It is better to ask and appear ignorant, than to remain silent and remain ignorant.
Oracle OCP DBA 9i,
C++, Java developer
2 completely different queries can hash to the same value. You'd be better off using address for finding the correct sql_text; better still a combination of address and hash_value.
Click Here to Expand Forum to Full Width