OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » ideal sessions

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ideal sessions [message #118725]

Sat, 07 May 2005 06:02

mostafa71
Messages: 18
Registered: May 2005

Junior Member

hi
is there ay parameter specify the ideal time for oracle sessions so that after this time it must disconnect?

Report message to a moderator

Re: ideal sessions [message #118739 is a reply to message #118725]

Sat, 07 May 2005 11:15

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

You can create a profile that limits IDLE_TIME and assign it to the required users. Remember to also set the RESOURCE_LIMIT parameter to TRUE to enforce your profile.

Quick example:

SQL> CREATE PROFILE my_profile LIMIT idle_time 30;

Profile created.

SQL> ALTER USER scott PROFILE my_profile;

User altered.

For more info, see the SQL Reference Guide.

Best regards.

Frank

Report message to a moderator

Previous Topic:	How to execute a unix command from Oracle ?
Next Topic:	urgent help!!!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 04:26:38 CST 2025