Home » RDBMS Server » Server Administration » Resource limit (Oracle 9.2.0.8)
Resource limit [message #335118] Mon, 21 July 2008 01:28 Go to next message
udara
Messages: 9
Registered: July 2008
Location: COLOMBO
Junior Member
I need to restric some users no of logins to system. example no of session per user need to restric to 2 only. I create a profile and set it as following


ALTER PROFILE developer LIMIT sessions_per_user 2;

let me know any other concerns to correct this
Thanks
Re: Resource limit [message #335120 is a reply to message #335118] Mon, 21 July 2008 01:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to set the RESOURCE_LIMIT parameter to TRUE.

You have to know that some GUI starts several sessions at connection and even a connection per window/tab.

Regards
Michel
Re: Resource limit [message #335140 is a reply to message #335120] Mon, 21 July 2008 03:45 Go to previous messageGo to next message
udara
Messages: 9
Registered: July 2008
Location: COLOMBO
Junior Member
resource_limit , does it impact to other acctivites in the system?
Re: Resource limit [message #335144 is a reply to message #335140] Mon, 21 July 2008 03:49 Go to previous message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
From doc:
Quote:
RESOURCE_LIMIT determines whether resource limits are enforced in database profiles.

Regards
Michel
Previous Topic: Monitoring Parallel Execution
Next Topic: Problem with synonym
Goto Forum:
  


Current Time: Fri Dec 02 12:14:20 CST 2016

Total time taken to generate the page: 0.09600 seconds