Hi, We have an Oracle database 8.1.6.3.7 running in NT. We use Oracle Client 8.1.7.3 with OLE DB connect to database. There are two Web server connect to this database. First Web server have 20 constant connections to the database. The second Web Server makes vary connections and always drop connect after the application finish. The memory usage of Oracle.exe process increases when the Second Web server make connections. But after those connections drop, the memory decrease very little.
For example, before the second Web server make connections, Oracle.exe uses 200M virtual memory. When the Web server make 20 connections, Oracle.exe uses 300M virtual memory. After those 20 connections drop, the Oracle.exe still uses 260M virtual memory. Over some period, Oracle.exe will run out of memory. Any idea what went wrong? How to solve this problem? Brian Chen (212)-931-1878 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chen, Brian INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).