Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: inactive users how find

Re: inactive users how find

From: <sybrandb_at_hccnet.nl>
Date: Wed, 13 Jun 2007 20:36:34 +0200
Message-ID: <b7e07311hdl3da0d7beupsa88e5i3nm87i@4ax.com> 





On Wed, 13 Jun 2007 11:32:58 -0700, "fitzjarrell_at_cox.net"
<fitzjarrell_at_cox.net> wrote:



>I would thoroughly investigate every suspect session before you kill

>it.




LAST_CALL_ET contains the number of seconds the session has been
inactive. Inactive means: not executing a sql statement.
LAST_CALL_ET is reset every time a sql statement is executed.


-- 
Sybrand Bakker
Senior Oracle DBA


Received on Wed Jun 13 2007 - 13:36:34 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US