理解v$sql的exact_matching_signature与force_matching_signature
对SQL语句，去掉重复的空格（不包括字符常量），将大小写转换成相同，比如均为大写（不包括字符常量）后，如果SQL相同，那么SQL语句的exact_matching_signature就是相同的。
对SQL语句，去掉重复的空格（不包括字符常量），将大小写转换成相同，比如均为大写（不包括字符常量），然后去掉SQL中的常量，如果SQL相同，那么SQL语句的force_matching_signature就是相同的。
但是例外的情况是：如果SQL中有绑定变量，force_matching_signature就会与exact_matching_signature一样的生成标准。
select /*+ findme */ name from t01 where id=2; select /*+ findme1 */ name from t01 where id=2; select /*+ findme */ Name from t01 where id=2; SELECT /*+ findme */ nAme FROM t01 WHERE id=2; SELECT /*+ Findme */ nAme FROM t01 WHERE id=2; SELECT /*+ Findme test */ nAme FROM t01 WHERE id=2; SELECT /*+ full(t01) Findme */ nAme FROM t01 WHERE id=2; SELECT /*+ index(t01) Findme */ nAme FROM t01 WHERE id=2; SQL> create table t01(id number,name varchar2(30)); SQL> insert into t01 values(1,'bb01'); SQL> insert into t01 values(2,'bb02'); SQL> insert into t01 values(3,'bb03'); SQL> insert into t01 values(4,'bb04'); SQL> insert into t01 values(5,'bb05'); SQL> select /*+ findme */ name from t01 where id=2; SQL> select /*+ findme1 */ name from t01 where id=2; SQL> select /*+ findme */ Name from t01 where id=2; SQL> SELECT /*+ findme */ nAme FROM t01 WHERE id=2; SQL> SELECT /*+ Findme */ nAme FROM t01 WHERE id=2; SQL> SELECT /*+ Findme test */ nAme FROM t01 WHERE id=2; SQL> SELECT /*+ full(t01) Findme */ nAme FROM t01 WHERE id=2; SQL> SELECT /*+ index(t01) Findme */ nAme FROM t01 WHERE id=2; SQL> select sql_text,force_matching_signature,exact_matching_signature from v$sql where lower(sql_text) like '%/*%findme%' and sql_text not like '%v$sql%'; SQL_TEXT FORCE_MATCHING_SIGNATURE EXACT_MATCHING_SIGNATURE -------------------------------------------------------------------------------- ------------------------ ------------------------ select /*+ findme */ Name from t01 where id=2 2.61638783165569E18 1.81667648323122E19 select /*+ findme1 */ name from t01 where id=2 1.48618482593165E19 3.84294405114677E18 select /*+ findme */ name from t01 where id=2 2.61638783165569E18 1.81667648323122E19 SELECT /*+ index(t01) Findme */ nAme FROM t01 WHERE id=2 8.64347201076369E18 1.06927716956949E19 SELECT /*+ full(t01) Findme */ nAme FROM t01 WHERE id=2 3.77473736948433E18 2.01226189844612E18 SELECT /*+ Findme */ nAme FROM t01 WHERE id=2 2.61638783165569E18 1.81667648323122E19 SELECT /*+ findme */ nAme FROM t01 WHERE id=2 2.61638783165569E18 1.81667648323122E19 SELECT /*+ Findme test */ nAme FROM t01 WHERE id=2 1.31270739882141E19 1.18833249442956E19 8 rows selected SQL> alter session set cursor_sharing=force; SQL> alter system flush shared_pool; SQL> select /*+ findme */ name from t01 where id=2; SQL> select /*+ findme1 */ name from t01 where id=2; SQL> select /*+ findme */ Name from t01 where id=2; SQL> SELECT /*+ findme */ nAme FROM t01 WHERE id=2; SQL> SELECT /*+ Findme */ nAme FROM t01 WHERE id=2; SQL> SELECT /*+ Findme test */ nAme FROM t01 WHERE id=2; SQL> SELECT /*+ full(t01) Findme */ nAme FROM t01 WHERE id=2; SQL> SELECT /*+ index(t01) Findme */ nAme FROM t01 WHERE id=2; SQL> select sql_text,force_matching_signature,exact_matching_signature from v$sql where lower(sql_text) like '%/*%findme%' and sql_text not like '%v$sql%'; SQL_TEXT FORCE_MATCHING_SIGNATURE EXACT_MATCHING_SIGNATURE -------------------------------------------------------------------------------- ------------------------ ------------------------ select /*+ findme1 */ name from t01 where id=:"SYS_B_0" 1.48618482593165E19 1.48618482593165E19 select /*+ findme */ Name from t01 where id=:"SYS_B_0" 2.61638783165569E18 2.61638783165569E18 select /*+ findme */ name from t01 where id=:"SYS_B_0" 2.61638783165569E18 2.61638783165569E18 SELECT /*+ index(t01) Findme */ nAme FROM t01 WHERE id=:"SYS_B_0" 8.64347201076369E18 8.64347201076369E18 SELECT /*+ Findme test */ nAme FROM t01 WHERE id=:"SYS_B_0" 1.31270739882141E19 1.31270739882141E19 SELECT /*+ Findme */ nAme FROM t01 WHERE id=:"SYS_B_0" 2.61638783165569E18 2.61638783165569E18 SELECT /*+ full(t01) Findme */ nAme FROM t01 WHERE id=:"SYS_B_0" 3.77473736948433E18 3.77473736948433E18 SELECT /*+ findme */ nAme FROM t01 WHERE id=:"SYS_B_0" 2.61638783165569E18 2.61638783165569E18 8 rows selected SQL>