you need to set set idle-time-parameter in a new profile.
when you've done so you have to
- assign this profile to an user
- set the init-ora-parameter RESOURCE_LIMIT = TRUE

after that all users - which you have assigned to this profile - will
sniped after the time you've set in the profile.

hth
Rüdiger J. Schulz
www.sosys-berlin.de


Sreedhar_Bhaskararaju schrieb:

>Hi All,
>
>How to kill idle/inactive session automatically, based on its idle time? Which parameter should change?
>
>Regs,
>Sree
>
>
>
>
>


Oracle LazyDBA home page