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: 185
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?
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: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No limit unless you set one with a PROFILE.

Regards
Michel
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
Previous Topic: Oracle allocate extent size strategy
Next Topic: Configuring ASM Diskgroup on RAID5
Goto Forum:
  


Current Time: Sat Dec 10 16:44:11 CST 2016

Total time taken to generate the page: 0.23390 seconds