RE: Session

Thanks,

Paul  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jeffrey Beckstrom
Sent: Monday, March 02, 2015 10:45 AM
To: cure_at_austin.rr.com; 'Oracle Mailinglist' Subject: Re: Session  

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