Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: inactive users how find
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 DBAReceived on Wed Jun 13 2007 - 13:36:34 CDT