Idle timeout

[DB_Lover]

Hi,
I created a profile with idle timeout option 5 minutes. Then I assigned this profile to a user. I used this user name to connect using SQL plus. Even there is no activity for 5 minutes or more the user don't get disconnected. Is there other setting I should do to accomplish that ??

regards,

[sambavan]

Yeah, issue

sqlplus SYS/syspassword@service_name
SQL> ALTER SYSTEM SET RESOURCE_LIMIT=TRUE;

also include the RESOURCE_LIMIT=TRUE in the initsid.ora file such that when you get to restart your instance next time this becomes effective automatically.

Sam

[DB_Lover]

Thank you for the quick reply.
I have resource_limit already set to true but still not working.
I use Oracle 7.3.4.

Regrads

[Oracledba8]

Ok,

Please Follow these Steps.
Create Profile prof1 Limit Idle_Time 5;

Alter system Set Resource_Limit = True;

Alter User username Profile Prof1;

Connect That user, do any select and leave the session opened for five minutes, then Issue any select , You will get the Error that not Connect or so.

This parameter sessting is only as long as the Instance is Running. If you shutdown the Database that will be false.

Any Transactions Pending in that session will be rolled back.

Hope this will work.
Thanks