Oracle9 Tuning for WindowsServer2003
Posted on 2004-09-14
We have had some crashes lately in our production database that has about 550 concurrent connections using a shared server configuration and all of the crashes have alert.log entries like: "found dead shared server..." or "found dead dispatcher...". We had to switch to shared server (from dedicated) a year ago when we hit 350 concurrent connections.
Does anyone have successful experience configuring Oracle9.2 for WindowsServer2003 to support more than 500 connections?
Or, has anyone tried running two instances on one Windows server that both use the same database?