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

Report message to a moderator

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: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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?

Report message to a moderator

Re: Resource limit [message #335144 is a reply to message #335140] Mon, 21 July 2008 03:49 Go to previous message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
From doc:
Quote:
RESOURCE_LIMIT determines whether resource limits are enforced in database profiles.

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Feb 24 12:41:16 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.