每天执行两次 oracle,连续两次执行一模一样的sql语句，为什么hash

这个博客展示了在Oracle数据库中创建表`tmaclean`并进行查询的操作。使用`SELECT * FROM tmaclean`两次显示没有记录。进一步通过`V$SQL`视图查找与`tmaclean`相关的SQL语句，分析了SQL文本及其哈希值。

摘要由CSDN通过智能技术生成

INSTANCE_NAME

----------------

Parnassus

SQL>

SQL> create table tmaclean(t1 int);

Table created.

SQL> select * from tmaclean ;

no rows selected

SQL> select * from tmaclean;

no rows selected

SQL> select hash_value,sql_id,SQL_TEXT from V$SQL Where SQL_TEXT like '%tmaclean%' and sql_text not like '%like%';

HASH_VALUE SQL_ID

---------- -------------

SQL_TEXT

--------------------------------------------------------------------------------------------------------------------------------------------

2383741951 6ukmcfy71a0zz

select * from tmaclean

2075201426 bna182txv23wk

select * from tmaclean

SQL> select hash_value,SQL_ID,SQL_TEXT,dump(SQL_TEXT,16) from V$SQL Where SQL_TEXT like '%tmaclean%' and sql_text not like '%like%';

HASH_VALUE SQL_ID

---------- -------------

SQL_TEXT

--------------------------------------------------------------------------------------------------------------------------------------------

DUMP(SQL_TEXT,16)

--------------------------------------------------------------------------------------------------------------------------------------------

2383741951 6ukmcfy71a0zz

select * from tmaclean

Typ=1 Len=22: 73,65,6c,65,63,74,20,2a,20,66,72,6f,6d,20,74,6d,61,63,6c,65,61,6e

2075201426 bna182txv23wk

select * from tmaclean

Typ=1 Len=23: 73,65,6c,65,63,74,20,2a,20,66,72,6f,6d,20,74,6d,61,63,6c,65,61,6e,20

每天执行两次 oracle,连续两次执行一模一样的sql语句，为什么hash_value不一样？...