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