tag:blogger.com,1999:blog-8873109125023142810.post849464467021832758..comments2024-03-29T06:56:24.360+05:30Comments on Let's Develop in Oracle: ORA-00018 maximum number of sessions exceededNimish Garghttp://www.blogger.com/profile/15795821721808548808noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-8873109125023142810.post-53055955028434690482016-03-02T06:19:55.298+05:302016-03-02T06:19:55.298+05:30Hi Nimish: A small query:- Is there a reason behin...Hi Nimish: A small query:- Is there a reason behind all the below calculations <br /> if Processes=x then Sessions = x * 1.1 + 5 and <br /> Transactions = Sessions * 1.1<br />Or is it the ideal scenario....<br /><br /><<<< I have got another doubt (not related to this article): How the High Water Mark is useful in real time scenario.....If you could write an article on this too then it will be useful. >>>><br />SKNnoreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-61034363698916524322014-04-28T14:52:39.676+05:302014-04-28T14:52:39.676+05:30greatgreatAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-66995510393841848922013-12-05T14:34:44.519+05:302013-12-05T14:34:44.519+05:30NO, it requires re-start of instanceNO, it requires re-start of instanceNimish Garghttps://www.blogger.com/profile/15795821721808548808noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-37741236299574539132013-12-05T12:41:06.264+05:302013-12-05T12:41:06.264+05:30Can i change this online?Can i change this online?Anonymoushttps://www.blogger.com/profile/05596516272767347617noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-62351674430292577242013-10-16T18:44:21.387+05:302013-10-16T18:44:21.387+05:30Sessions initialization parameter says how many di...Sessions initialization parameter says how many different sessions can be created by multiple clients at a single point of time.<br /><br />db connection pooling is a done at middle tier (application server) so that application can avoid the overhead to create and drop connections for each and every transaction. Application creates N connections to DB and put them in a connection pool and which can be reused when future requests to the database are required.<br /><br />http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:22140261281764Nimish Garghttps://www.blogger.com/profile/15795821721808548808noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-39429639142784619762013-10-16T15:55:32.102+05:302013-10-16T15:55:32.102+05:30Hi,
I want to know that the SESSION initialization...Hi,<br />I want to know that the SESSION initialization parameter would be same as db connection pool for oracle database?<br />OR<br />what is the difference between SESSION initialization parameter and db connection pool in oracle database?<br />Anonymoushttps://www.blogger.com/profile/13193287671335593631noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-60569937488074577912013-05-24T18:17:49.812+05:302013-05-24T18:17:49.812+05:30Awesome! thanks for the solution !Awesome! thanks for the solution !Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-29046612746498905452012-05-14T13:06:43.915+05:302012-05-14T13:06:43.915+05:30http://nimishgarg.blogspot.in/2012/05/ora-00020-ma...http://nimishgarg.blogspot.in/2012/05/ora-00020-maximum-number-of-processes.html might be useful to youNimish Garghttps://www.blogger.com/profile/15795821721808548808noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-15920135172180604042012-02-25T02:39:15.616+05:302012-02-25T02:39:15.616+05:30Great upload...to the point. My install is runnin...Great upload...to the point. My install is running smooth now.<br /><br />Regards, Scott N.ScottNhttps://www.blogger.com/profile/17983982333024742186noreply@blogger.com