Idle Time

[M.Shakeel Azeem]

dear all

i want to disconnect all the users who r inactive for 15 minutes

1- All the users are assigned default profile

1 select username,profile
2 from dba_users
3* where username in ('NCL','HR','SCOTT')
SQL> /

USERNAME PROFILE
-------------------- --------------
SCOTT DEFAULT
NCL DEFAULT
HR DEFAULT


2- SQL>alter profile default limit idle_time 15;

1 select profile,resource_name,limit from dba_profiles
2 where profile='DEFAULT'
3* and resource_name='IDLE_TIME'

PROFILE RESOURCE_NAME LIMIT
-------- ---------------- ------
DEFAULT IDLE_TIME 15

But the users are not never disconnected even after having 30 minutes inactive sessions

Can anybody help me in this regard;

[davey23uk]

is resource_limit set to true?