v$sql : sql « System Tables Data Dictionary « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Tables Data Dictionary
3. sql

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 * 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>