Hi,
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.
Please explain
Seelan
Printable View
Hi,
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.
Please explain
Seelan
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.
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.