I have a question regarding the use of oracle native drivers with oracle 8i and cf 5. We have a user account set up for coldfusion that allows 50 connections. However at any given time even under extreme load only one connection is actively doing anything in oracle. The other connections just sit idle. Durring this time we are also seeing huge numbers of timeouts and restarts. We have worked with all the settings in cf administrator and have come to the conclusion (and confimed with our macromedia tech) that the problem is not in the cfsettings or the application. If we set up a different datasource using another user account and hit the database another connection instantly becomes active. To me this suggests that although the account set up for cf has 50 available connections to oracle, oracle is limiting processing to only a single connection at any one time.
I have very little administrative experience in oracle so I cannot properly explain to our dba what may be going on or how to fix it. Can anyone help me on this? A: how is it possible that the issue I elude to above is actually happening. B: what can be done to allow multiple connections to process simultaneously in oracle. thanks frederic ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
