RE: Time out session
- From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
- To: "'tomday2@xxxxxxxxx'" <tomday2@xxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Thu, 28 Oct 2004 11:55:52 -0400
Thomas,
The LAST_CALL_ET column signifies (in seconds) the last time a session did
*anything*. This value is a delta offset from sysdate.
So, the following query would show you the last time the session did any
work:
select username,logon_time,last_call_et,
to_char(sysdate-(last_call_et/(60*60*24)),'hh24:mi:ss') last_work_time
from v$session
where username is not null
You can compare this value with the "drilldown" value returned by OEM for a
session. You will see that this is the value that is returned.
I figured this out one by by tracing the OEM sql to see how they did this.
Good Luck!
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
From: Thomas Day [mailto:tomday2@xxxxxxxxx]
Sent: Thursday, October 28, 2004 11:35 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Time out session
Is there a way to time out an idle terminal connected to Oracle?
I have IDLE_TIME set to 20 in the profile and resource_limit is true.
This does not time out an idle terminal.
What is the meaning of the values in V_$SESSION.LAST_CALL_ET? Oracle
documentation is less than illuminating. All it says is "LAST_CALL_ET
NUMBER The last call". This is from Oracle9i Database Reference,Release 2
(9.2),Part Number A96536-02.
Any help, examples, or stories of "how we did it" would be greatly
appreciated.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
