| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: What is a SQL statement ID?
The hash value is the high speed method for locating the statement, but the unique identifier in v$sql is
(hash_value, address, child_number)
In Oracle 10g, there is a new column called the sql_id
which is closer to unique (less chance of collision) than
the hash_value, and this also has a high-speed access
path into v$sql. (But again, is only unique there when
combined with address and child_number)
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/seminar.html Optimising Oracle Seminar - schedule updated May 1st
List,
Can anybody tell me how to identify a SQL statement uniquely? I found some = people use sql address, some people use hash_value, some others use both? W= hat's the difference and the reasons?
Thanks,
Michael=20
This e-mail contains privileged attorney-client communications and/or confi= dential information, and is only for the use by the intended recipient. Rec= eipt by an unintended recipient does not constitute a waiver of any applica=ble privilege.
Reading, disclosure, discussion, dissemination, distribution or copying of = this information by anyone other than the intended recipient or his or her = employees or agents is strictly prohibited. If you have received this comm= unication in error, please immediately notify us and delete the original ma=terial from your computer.
Sempra Energy Trading Corp. (SET) is not the same company as SDG&E or SoCal= Gas, the utilities owned by SET's parent company. SET is not regulated by = the California Public Utilities Commission and you do not have to buy SET's= products and services to continue to receive quality regulated service fro=m the utilities.
 |
 |