prev_hash_value not changing in v$session [message #498570] |
Thu, 10 March 2011 05:23 |
OraKaran
Messages: 183 Registered: March 2008 Location: United Kingdom
|
Senior Member |
|
|
Hello
From 1 session {sid=314} (sqlplus) I am executing various queries and from other session I am querying sql_hash_value and prev_hash_value for the session with sid=314
However I found that the prev_hash_value for the first session which is executing various queries is not at all changing whereas it's sql_hash_value is constantly changing
What could be the reason?
SQL> select sql_hash_value,prev_hash_value from v$session where sid=314;
SQL_HASH_VALUE PREV_HASH_VALUE
-------------- ---------------
0 3383928886
SQL> select sql_hash_value,prev_hash_value from v$session where sid=314;
SQL_HASH_VALUE PREV_HASH_VALUE
-------------- ---------------
1451895371 3383928886
SQL> select sql_hash_value,prev_hash_value from v$session where sid=314;
SQL_HASH_VALUE PREV_HASH_VALUE
-------------- ---------------
1451895371 3383928886
SQL> select sql_hash_value,prev_hash_value from v$session where sid=314;
SQL_HASH_VALUE PREV_HASH_VALUE
-------------- ---------------
1284848732 3383928886
SQL> select sql_hash_value,prev_hash_value from v$session where sid=314;
SQL_HASH_VALUE PREV_HASH_VALUE
-------------- ---------------
1284848732 3383928886
SQL> select sql_hash_value,prev_hash_value from v$session where sid=314;
SQL_HASH_VALUE PREV_HASH_VALUE
-------------- ---------------
1284848732 3383928886
SQL> select sql_hash_value,prev_hash_value from v$session where sid=314;
SQL_HASH_VALUE PREV_HASH_VALUE
-------------- ---------------
1122213218 3383928886
Regards,
OraKaran
|
|
|
|
|
|
|
|
|