Re: Non-Activity timeout for user processes?

First create a profile:

CREATE PROFILE "IDLE_TIME" LIMIT CPU_PER_SESSION UNLIMITED CPU_PER_CALL

UNLIMITED CONNECT_TIME UNLIMITED IDLE_TIME 30 SESSIONS_PER_USER
UNLIMITED LOGICAL_READS_PER_SESSION UNLIMITED LOGICAL_READS_PER_CALL
UNLIMITED PRIVATE_SGA UNLIMITED COMPOSITE_LIMIT UNLIMITED

PASSWORD_GRACE_TIME UNLIMITED PASSWORD_LIFE_TIME UNLIMITED
PASSWORD_REUSE_MAX UNLIMITED PASSWORD_REUSE_TIME UNLIMITED
PASSWORD_VERIFY_FUNCTION UNLIMITED;

Assign the profile to the user:

ALTER USER "DEMO" PROFILE "IDLE_TIME"; This will check the idle time the user has incurred and will log them off after 30 minutes of idle time.

• Fernando

Marcel Carbone wrote:
>
> I am trying to drop user processes that have not had any activity for 30
> minutes. Does anyone know how this can be done?
>
> Thanks in Advance
>
> Marcel Carbone
Received on Mon May 01 2000 - 00:00:00 CDT