Do you have Maintain Database Connections checked in the CFAdmin/Datasource
setup? Is your Oracle TNSListener working OK, and is your database in good
health? This looks like locking errors inside of Oracle. Also there are a
lot of issues with Open Cursors using CF/Oracle. Look at the OPEN_CURSORS
setting on your Oracle server to be sure that is high enough.
Cheers!
Robin Greenhagen
President
GreenSoft Solutions, Inc.
-----Original Message-----
From: Templin, Luke [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 26, 2001 10:19 AM
To: [EMAIL PROTECTED]
Subject: [KCFusion] Performance Issues again
Our intranet application has trouble handling high loads. The cf service
seems to hang and we have a number of errors that occur repeatedly.
We're running CF 4.5 on 2 Compaq Proliant 7000 NT Web servers with IIS 4
and NT Sp6.
The database is a Dec Alpha running Oracle 8.1.6.0. We connect to the
database using both the native drivers and odbc connections
The errors we see are:
Oracle Error Code = 0Timeout while obtaining an Oracle connection lock
Oracle Error Code = 0Timeout while obtaining an Oracle statement lock
Oracle Error Code = 24334ORA-24334: no descriptor for this position SQL =
"various sql statements"
Has anybody successfully eliminated these from occurring?
Luke Templin
Software Eng.
> Sprint PCS - IT AD/CRM Business Dev & Corp. Systems
(913) 906-4928 Office
(913) 219-6301 PCS
(913) 614-1103 Pager
______________________________________________________________________
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives........ http://www.mail-archive.com/[email protected]
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe.................... mailto:[EMAIL PROTECTED]
To Unsubscribe................ mailto:[EMAIL PROTECTED]
______________________________________________________________________
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives........ http://www.mail-archive.com/[email protected]
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe.................... mailto:[EMAIL PROTECTED]
To Unsubscribe................ mailto:[EMAIL PROTECTED]
