my Question is
How to view and change the session time out or IDLE_TIME in oracle 9i

in other word each session should be experied afer (n) seconds when it become idel ,, how to change the value of the time


Thanks in advance and I woild approcialte your help

hi yafi

to control session idle time u have to

1- create / alter profile and set idle_time to needed value in min
2- set resource_limit parameter to TRUE, it is dynamic
3- change user profile to profile that has idle_time limit