Home » RDBMS Server » Server Administration » information about maximum number of connection of a particular user
information about maximum number of connection of a particular user [message #553194] Wed, 02 May 2012 09:10 Go to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
hello experts,
will you please tell me that how many maximum connection, a particular user can have in oracle.
and how many maximum connection if user has 'resource profile' as default.
and i am using oracle 11.2.0.1.0
thanx in advance.

Report message to a moderator

Re: information about maximum number of connection of a particular user [message #553200 is a reply to message #553194] Wed, 02 May 2012 09:20 Go to previous message
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
Senior Member
Query dba_profiles to find out what the limit is. We've no way of knowing what may have been done in your database.

Report message to a moderator

Previous Topic: do I need access to db server machine login ?
Next Topic: upgrade oracle 11.2.0.1 to 11.2.0.2
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 29 02:47:30 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.