Increasing Maximum number of Oracle connections.

Posted on 2003-02-19
Medium Priority
Last Modified: 2008-01-09

How does one increase the maximum number of simultaneous database connections that Oracle 8i (under Linux) can accept?

I'm using mod_perl with DBI/DBD and connecting from web scripts as well as a bunch of other places, and after a while all my connections begin to fail until I stop everything and start it again.

Question by:ChrisDrake
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Expert Comment

ID: 7984940
uh you get rid of oracle and buy a processor license for sql server, and you no longer have to worry about that kind of thing anymore.

are you seriously asking how to get around oracles bs licensing?
LVL 22

Expert Comment

by:Helena Marková
ID: 7986250
Maybe you can find useful information on this site:

Author Comment

ID: 7989142
No, this is a configuration, not a licensing issue: I recall choosing a number years ago when we installed the system, and to my regret now, I picked a number that was too small.

Anyhow - isn't SQL server a Microsoft thing?  Last time I checked bill wasn't letting Linux run his products (despite loosing that court thingo a few years back :-) ... not to mention that 9 out of 10 dead web sites I encounter return lame SQL Server error messages - who in their right mind would switch away from the worlds most reliable, leading, database product?

(There's a good reason why Larry is as rich as Bill !)
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Accepted Solution

__Holly__ earned 100 total points
ID: 7994834
sql server beats oracle any day of the week. check out www.tpc.org -- if you have larger than 100gb in an OLTP you need help...

its not the databases fault that there are crappy web developers out there.

i dont know what dead websites your talking about-- personally, if i were you, i would take this knowledge and go and sell them on your oracle crap.

just try not to make too many connections, ok?

LVL 22

Assisted Solution

by:Helena Marková
Helena Marková earned 100 total points
ID: 8006516

Expert Comment

by:Tom Knowlton
ID: 9432414
No comment has been added lately (214 days), so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area for this question:

RECOMMENDATION: split points between __Holly__ http:#7994834 and Henka http:#8006516

Please leave any comments here within 7 days.

-- Please DO NOT accept this comment as an answer ! --


EE Cleanup Volunteer

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question