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.
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-lReceived on Mon Mar 02 2015 - 17:45:24 CET