if you want to make the profile work you have to set set
RESOURCE_LIMIT-Parameter (init.ora/spfile) to TRUE

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




Sreedhar_Bhaskararaju schrieb:

>Hi all,
>
>I changed RESOURCE_LIMIT=TRUE
>
>CREATE PROFILE limit_idle_time LIMIT IDLE_TIME 1
>/
>
>ALTER USER tdb PROFILE limit_idle_time
>/
>
>But the session which is opened by tdb user is not killing up after 1 minute idle time.
>
>Is there any settings?
>
>Sree
>
>
>
>


Oracle LazyDBA home page