thanks for ur help.you are right the RESOURCE_LIMIT is FALSE.i made it true through the svrmgr30 and after running the query
select * from v$parameter where name = 'resource_limit';
it is showing me TRUE.
but still the user is not getting disconnected.if i type at sql prompt SHOW USER it is still showing me the user.pls tell me how do i know the user is disconnected.will it show me something??pls help me if iam doing something wrong.
the help is really appreciated.
thanks in advance
You may be misunderstood of the Term, Disconected. The user will be disconceted after that specified time but the session will still be active there for that user, even user is Disconnected.
Suppose you have assigned Idel_time 5, and assign this to a user and set the resource_limit to True, the user will be disconneted after five minutes if he is does not do any thing and any transactions will be rollbacked and Keep in Mind that Long queries running on Database from that user will not be counted as Idle Time.
Try to assign that Profile to a user, set Resource Limit to Tru, Connect that user and Just run a simple Update Statement and leave that session open for specified time, then issue any statement, You will get You are Connected.