OraFAQ Forum: Server Administration » IDLE

Home » RDBMS Server » Server Administration » IDLE_TIME

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

IDLE_TIME [message #213779]

Fri, 12 January 2007 04:54

M.Shakeel Azeem
Messages: 226
Registered: September 2006

Senior Member

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;

Report message to a moderator