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: Brian Peasland <dba_at_nospam.peasland.net>
Date: Wed, 13 Jun 2007 14:04:30 -0500
Message-ID: <4670337f$0$16379$88260bb3@free.teranews.com>


fitzjarrell_at_cox.net wrote:
> On Jun 13, 1:36 pm, sybra..._at_hccnet.nl wrote:

>> On Wed, 13 Jun 2007 11:32:58 -0700, "fitzjarr..._at_cox.net"
>>
>> <fitzjarr..._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

>
> I wasn't certain what columns exist in the 8.1.7.4 version of V
> $SESSION. Such information certainly would help in deciding which
> sessions were truly idle.
>
>
> David Fitzjarrell
>

To the OP: you could also implement a profile to automatically kill a session that is idle too long.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com
Received on Wed Jun 13 2007 - 14:04:30 CDT

Original text of this message

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