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

Thread: Hash_value

Hybrid View

  1. 06-09-2004, 05:39 AM #1
    seelan
    seelan is offline Member
    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
    Reply With Quote Reply With Quote
  2. 06-09-2004, 09:38 AM #2
    rotem_fo
    rotem_fo is offline Hangin Around,,,
    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
    Reply With Quote Reply With Quote
  3. 06-09-2004, 05:40 PM #3
    Axr2
    Axr2 is offline Senior Advisor
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width