SQL> select * from dual;
select * from DUAL;
D
-
X
SQL>
SQL> select sql_text, hash_value from v$sql
2 where upper(sql_text) = 'SELECT * FROM DUAL';
SQL_TEXT HASH_VALUE
----------
select * from dual 942515969
SQL> alter session set OPTIMIZER_MODE = first_rows;
Session altered.
SQL>
SQL> select * from dual;
D
-
X
SQL> select sql_text, hash_value, parsing_user_id
2 from v$sql
3 where upper(sql_text) = 'SELECT * FROM DUAL';
SQL_TEXT HASH_VALUE PARSING_USER_ID
---------- ---------------
select * from dual 942515969 38
select sql_text, hash_value, parsing_user_id, optimizer_mode
from v$sql
where upper(sql_text) = 'SELECT * FROM DUAL';
SQL>