Re: Session

From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Mon, 02 Mar 2015 11:45:24 -0500
Message-Id: <54F44D540200000B0053946D_at_groupwise.gcrta.org>



The statement probably is not active.

>>> "Paul Harrison" <cure_at_austin.rr.com> 3/2/15 11:42 AM >>>

Hi All,  

The sql_hash_value and sql_id is 0 and null from the v$session view. Any idea why ?    

sqlplus scott/scott  

select * from cust where cust_id = 998;  

   CUST_ID LAST_NAME FIRST_NAME

---------- ------------------------------ ------------------------------
	   998 998  						  998
	   998 998  						  998
	   998 998  						  998
	   998 998  						  998
 

select HASH_VALUE,SQL_TEXT from v$sql where sql_text = 'select * from cust where cust_id = 998';  

HASH_VALUE SQL_TEXT

---------- --------------------------------------------------
270457607 select * from cust where cust_id = 998    

SQL> select sql_hash_value,sql_id
  2 from v$session
  3 where username = 'SCOTT'
  4 ;  

SQL_HASH_VALUE SQL_ID
-------------- -------------

                         0 NULL   Thanks,
Paul

.

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Mar 02 2015 - 17:45:24 CET

Original text of this message