RE: What is a SQL statement ID?

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Fri, 2 Jul 2004 18:21:54 +0200
Message-ID: <JFEEIGBIDOCCDALDIPLNEEIECFAA.lex.de.haan@naturaljoin.nl>

statement identifiers are rather new in Oracle, and they are "more unique" than hash values ;-) Kind regards,
Lex.

---

visit my website at http://www.naturaljoin.nl

---

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Michael Wu Sent: Friday, July 02, 2004 17:19
To: oracle-l_at_freelists.org
Subject: What is a SQL statement ID?

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

• Binary/unsupported file stripped by Ecartis --
• Type: text/x-vcard
• File: Lex de Haan.vcf

  ---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Fri Jul 02 2004 - 11:18:58 CDT