• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2960
  • Last Modified:

Increasing Maximum number of Oracle connections.

Hi,

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.

Thanks.
0
ChrisDrake
Asked:
ChrisDrake
2 Solutions
 
__Holly__Commented:
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?
0
 
Helena Markováprogrammer-analystCommented:
Maybe you can find useful information on this site:
http://asktom.oracle.com/
0
 
ChrisDrakeAuthor Commented:
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 !)
0
Industry Leaders: 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!

 
__Holly__Commented:
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?

0
 
Helena Markováprogrammer-analystCommented:
0
 
Tom KnowltonWeb developerCommented:
ChrisDrake,
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 ! --

Thanks,

knowlton
EE Cleanup Volunteer
0

Featured Post

Technology Partners: 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!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now