blog.tanelpoder.com/2009/02/22/sql_id-is-just-a-fancy-representation-of-hash-value

Preview meta tags from the blog.tanelpoder.com website.

Linked Hostnames

7

Search Engine Appearance

Google

https://blog.tanelpoder.com/2009/02/22/sql_id-is-just-a-fancy-representation-of-hash-value

SQL_ID is just a fancy representation of hash value - Tanel Poder Consulting

…Or in other words, how to translate SQL_ID to a hash value :) I once wrote a script to demo this in my Advanced Oracle Troubleshooting class. Check this, I’ll run a query and then check what is its SQL_ID and HASH_VALUE from V$SQL: SQL> select * from dual; D - X SQL> select sql_id, hash_value from v$sql 2 where sql_text = 'select * from dual'; SQL_ID HASH_VALUE ------------- ---------- a5ks9fhw2v9s1 942515969 So, V$SQL reports the real SQL_ID and HASH_VALUE above. Now lets use my i2h.sql script ( i2h stands for: sql Id to Hash value ): SQL> @i2h a5ks9fhw2v9s1 SQL_ID HASH_VALUE ------------- ---------- a5ks9fhw2v9s1 942515969 It works! :) The code itself is simple (and you can download the script from here) - Linux, Oracle, SQL performance tuning and troubleshooting - consulting & training.



Bing

SQL_ID is just a fancy representation of hash value - Tanel Poder Consulting

https://blog.tanelpoder.com/2009/02/22/sql_id-is-just-a-fancy-representation-of-hash-value

…Or in other words, how to translate SQL_ID to a hash value :) I once wrote a script to demo this in my Advanced Oracle Troubleshooting class. Check this, I’ll run a query and then check what is its SQL_ID and HASH_VALUE from V$SQL: SQL> select * from dual; D - X SQL> select sql_id, hash_value from v$sql 2 where sql_text = 'select * from dual'; SQL_ID HASH_VALUE ------------- ---------- a5ks9fhw2v9s1 942515969 So, V$SQL reports the real SQL_ID and HASH_VALUE above. Now lets use my i2h.sql script ( i2h stands for: sql Id to Hash value ): SQL> @i2h a5ks9fhw2v9s1 SQL_ID HASH_VALUE ------------- ---------- a5ks9fhw2v9s1 942515969 It works! :) The code itself is simple (and you can download the script from here) - Linux, Oracle, SQL performance tuning and troubleshooting - consulting & training.



DuckDuckGo

https://blog.tanelpoder.com/2009/02/22/sql_id-is-just-a-fancy-representation-of-hash-value

SQL_ID is just a fancy representation of hash value - Tanel Poder Consulting

…Or in other words, how to translate SQL_ID to a hash value :) I once wrote a script to demo this in my Advanced Oracle Troubleshooting class. Check this, I’ll run a query and then check what is its SQL_ID and HASH_VALUE from V$SQL: SQL> select * from dual; D - X SQL> select sql_id, hash_value from v$sql 2 where sql_text = 'select * from dual'; SQL_ID HASH_VALUE ------------- ---------- a5ks9fhw2v9s1 942515969 So, V$SQL reports the real SQL_ID and HASH_VALUE above. Now lets use my i2h.sql script ( i2h stands for: sql Id to Hash value ): SQL> @i2h a5ks9fhw2v9s1 SQL_ID HASH_VALUE ------------- ---------- a5ks9fhw2v9s1 942515969 It works! :) The code itself is simple (and you can download the script from here) - Linux, Oracle, SQL performance tuning and troubleshooting - consulting & training.

  • General Meta Tags

    7
    • title
      SQL_ID is just a fancy representation of hash value | Tanel Poder Consulting
    • charset
      utf-8
    • viewport
      width=device-width, initial-scale=1
    • msapplication-TileColor
      #da532c
    • theme-color
      #ffffff

  • Open Graph Meta Tags

    2
    • og:title
      SQL_ID is just a fancy representation of hash value - Tanel Poder Consulting
    • og:description
      …Or in other words, how to translate SQL_ID to a hash value :) I once wrote a script to demo this in my Advanced Oracle Troubleshooting class. Check this, I’ll run a query and then check what is its SQL_ID and HASH_VALUE from V$SQL: SQL> select * from dual; D - X SQL> select sql_id, hash_value from v$sql 2 where sql_text = 'select * from dual'; SQL_ID HASH_VALUE ------------- ---------- a5ks9fhw2v9s1 942515969 So, V$SQL reports the real SQL_ID and HASH_VALUE above. Now lets use my i2h.sql script ( i2h stands for: sql Id to Hash value ): SQL> @i2h a5ks9fhw2v9s1 SQL_ID HASH_VALUE ------------- ---------- a5ks9fhw2v9s1 942515969 It works! :) The code itself is simple (and you can download the script from here) - Linux, Oracle, SQL performance tuning and troubleshooting - consulting & training.

  • Twitter Meta Tags

    2
    • twitter:title
      SQL_ID is just a fancy representation of hash value - Tanel Poder Consulting
    • twitter:description
      …Or in other words, how to translate SQL_ID to a hash value :) I once wrote a script to demo this in my Advanced Oracle Troubleshooting class. Check this, I’ll run a query and then check what is its SQL_ID and HASH_VALUE from V$SQL: SQL> select * from dual; D - X SQL> select sql_id, hash_value from v$sql 2 where sql_text = 'select * from dual'; SQL_ID HASH_VALUE ------------- ---------- a5ks9fhw2v9s1 942515969 So, V$SQL reports the real SQL_ID and HASH_VALUE above. Now lets use my i2h.sql script ( i2h stands for: sql Id to Hash value ): SQL> @i2h a5ks9fhw2v9s1 SQL_ID HASH_VALUE ------------- ---------- a5ks9fhw2v9s1 942515969 It works! :) The code itself is simple (and you can download the script from here) - Linux, Oracle, SQL performance tuning and troubleshooting - consulting & training.

  • Item Prop Meta Tags

    1
    • description
      …Or in other words, how to translate SQL_ID to a hash value :) I once wrote a script to demo this in my Advanced Oracle Troubleshooting class. Check this, I’ll run a query and then check what is its SQL_ID and HASH_VALUE from V$SQL: SQL> select * from dual; D - X SQL> select sql_id, hash_value from v$sql 2 where sql_text = 'select * from dual'; SQL_ID HASH_VALUE ------------- ---------- a5ks9fhw2v9s1 942515969 So, V$SQL reports the real SQL_ID and HASH_VALUE above. Now lets use my i2h.sql script ( i2h stands for: sql Id to Hash value ): SQL> @i2h a5ks9fhw2v9s1 SQL_ID HASH_VALUE ------------- ---------- a5ks9fhw2v9s1 942515969 It works! :) The code itself is simple (and you can download the script from here) - Linux, Oracle, SQL performance tuning and troubleshooting - consulting & training.

  • Link Tags

    5
    • apple-touch-icon
      /apple-touch-icon.png
    • icon
      /favicon-32x32.png
    • icon
      /favicon-16x16.png
    • manifest
      /site.webmanifest
    • mask-icon
      /safari-pinned-tab.svg

Links

17