incorrect last_call_et from v$session

From: Leon <lrzhemov_at_shaw.ca>
Date: 6 May 2002 17:57:22 -0700
Message-ID: <dac2c664.0205061657.69aedc2c@posting.google.com>

I am running Oracle 8.1.6 in RedHat linux

There is a problem with last_call_et. Enterprise manager shows incorrect last activity time as well

select logon_time,

       sysdate-last_call_et/(24*3600), 
       last_call_et 

from v$session

LOGON_TIME	SYSDATE-LAST_CALL_ET/(24*3600)	LAST_CALL_ET
5/2/2002 10:14:21 PM	3/22/1990 5:23:14 PM	382580957
5/2/2002 10:14:21 PM	3/22/1990 5:23:14 PM	382580957
5/2/2002 10:14:21 PM	3/22/1990 5:23:14 PM	382580957
5/6/2002 6:23:47 AM	10/25/1874 10:12:32 PM	4024409999
5/5/2002 2:44:31 PM	1/2/1920 5:21:40 PM	2598481851
5/6/2002 5:43:21 AM	4/26/1922 7:08:27 PM	2525467444
5/3/2002 9:04:11 PM	7/19/1943 4:49:09 PM	1855530202
5/6/2002 5:56:23 AM	5/1/1867 4:40:00 PM	4260647551
5/6/2002 4:53:26 AM	3/25/1921 2:46:24 AM	2559827167
5/6/2002 5:24:49 AM	11/28/1921 4:00:11 PM	2538352340
5/6/2002 5:52:22 PM	5/6/2002 5:52:31 PM	0
5/6/2002 4:49:54 AM	10/25/1874 10:12:32 PM	4024409999
5/2/2002 10:42:19 PM	3/21/1996 6:48:06 PM	193273465
5/2/2002 10:14:30 PM	5/6/2002 5:52:31 PM	0
5/6/2002 11:17:29 AM	12/14/1897 6:05:19 PM	3294258432
5/5/2002 2:44:18 PM	1/22/1916 3:02:11 AM	2723035820

Thanks
Leon Received on Mon May 06 2002 - 19:57:22 CDT