Home » RDBMS Server » Server Administration » Number of permissable sessions in oracle (Oracle 9i)
Number of permissable sessions in oracle [message #413565] Thu, 16 July 2009 07:59 Go to next message
manoj12
Messages: 210
Registered: March 2008
Location: India
Senior Member
Dear Sir

Could you please how many number of permissable sessions in one schema are there in oracle.Could you please tell me how to check that?

Report message to a moderator

Re: Number of permissable sessions in oracle [message #413571 is a reply to message #413565] Thu, 16 July 2009 08:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No limit unless you set one with a PROFILE.

Regards
Michel

Report message to a moderator

Re: Number of permissable sessions in oracle [message #413704 is a reply to message #413565] Fri, 17 July 2009 03:19 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
No limit, other than the value of the SESSIONS initialization parameter, which controls the total number of sessions on the Db

Report message to a moderator

Previous Topic: Oracle allocate extent size strategy
Next Topic: Configuring ASM Diskgroup on RAID5
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 00:57:51 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.