详解sql_id,hash_value,address,old_hash_value(二)
-------------
2556775619
因此，与hash_value相比，sql_id可以更有效的唯一表示一个sql语句。
补充：我们也可以通过dbms_utility.sqlid_to_sqlhash把sqlid转换为hash_value;通过dbms_sqltune_util1.sqltext_to_sqlid来获取某语句的sql_id
[sql]
SQL> select dbms_utility.sqlid_to_sqlhash('bhsz5y2c6am63') from dual;
DBMS_UTILITY.SQLID_TO_SQLHASH('BHSZ5Y2C6AM63')
----------------------------------------------
2556775619
[sql]
SQL>
select dbms_sqltune_util0.sqltext_to_sqlid('select 8888 from dual'||chr(0)) as sql_id from dual;
SQL_ID
------------------------------
bhsz5y2c6am63