Home » RDBMS Server » Server Administration » IDLE_TIME
IDLE_TIME [message #213779] Fri, 12 January 2007 04:54 Go to next message
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;
Re: IDLE_TIME [message #213781 is a reply to message #213779] Fri, 12 January 2007 04:59 Go to previous message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

You may find your answer
here
Previous Topic: Difference in ALTER commands with redo/archive logs
Next Topic: Problem about extents
Goto Forum:
  


Current Time: Mon Dec 05 10:48:50 CST 2016

Total time taken to generate the page: 0.09164 seconds