Hash_value
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Hash_value

  1. #1
    Join Date
    Jan 2003
    Location
    Bahrain
    Posts
    109

    Hash_value

    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

  2. #2
    Join Date
    Nov 2000
    Location
    Israel
    Posts
    268
    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

  3. #3
    Join Date
    Oct 2002
    Posts
    807
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width