From oracle-l-bounce@freelists.org Tue Nov 29 09:31:29 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id jATFVMgB003471 for ; Tue, 29 Nov 2005 09:31:24 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id jATFV1AX003375 for ; Tue, 29 Nov 2005 09:31:07 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D92CE23B283; Tue, 29 Nov 2005 10:30:45 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 20249-07; Tue, 29 Nov 2005 10:30:45 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 632AF23B11A; Tue, 29 Nov 2005 10:30:45 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 29 Nov 2005 10:28:51 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4904023B009 for ; Tue, 29 Nov 2005 10:28:51 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 19836-06 for ; Tue, 29 Nov 2005 10:28:51 -0500 (EST) Received: from nproxy.gmail.com (nproxy.gmail.com [64.233.182.192]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E5AF523AF90 for ; Tue, 29 Nov 2005 10:28:50 -0500 (EST) Received: by nproxy.gmail.com with SMTP id q29so589393nfc for ; Tue, 29 Nov 2005 07:28:50 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=IEiKDih3Mx6FJVq2BGim2tAisMKwy3NHg/E5iHcqMf5SpNMHB0N71R9rHaxwa4QSepU1GsxlXU5n5zI2IDfNs0gpORx4/FTSqpGGGEiNlaTpYpjQa8j4jQRKBAffWJfCnAPi+i0LKB6Plh2GBTRPfceymS6TUI4kTK+bgYrygu8= Received: by 10.48.246.18 with SMTP id t18mr592308nfh; Tue, 29 Nov 2005 07:28:50 -0800 (PST) Received: by 10.49.1.9 with HTTP; Tue, 29 Nov 2005 07:28:50 -0800 (PST) Message-ID: <910046b40511290728n25696589i1fe57b2f43559463@mail.gmail.com> Date: Tue, 29 Nov 2005 10:28:50 -0500 From: Paul Drake To: "oracle-l@freelists.org" Subject: maximum number of handles under an oracle.exe process (10gR1 w2k adv svr)? MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Content-Disposition: inline X-archive-position: 28743 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: bdbafh@gmail.com Precedence: normal Reply-To: bdbafh@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-3.4 required=5.0 tests=ADVERT_CODE2,AWL,BAYES_00, TO_ADDRESS_EQ_REAL autolearn=no version=2.63 Just polling ... What is the maximum number of handles under an OS process (namely, oracle.exe) that any of you have come across running Oracle 10g R1 std ed on win32 OSes (10.1.0.4)? I've never seen a published maximum value. Addition of concurrent users and datafiles to a stable system may have had a de-stabilizing effect now, or perhaps might in the near future. More than likely, its a memory allocation/consumption issue. I just wanted to rule out handles as a contributing factor. I'm hoping that someone has bumped into this before and is willing to share. thanks, Paul Aside #1 - win32 vs lin32 Apparently, RHEL or SuSE is not an option in the case Aside #2 - memory I am familiar with the limits for process/virtual memory on this OS. pga_aggregate_target, workarea_policy='AUTO'. orastack.exe has not been run against the oracle.exe executable, but that is being considered. 335 concurrent dedicated server sessions were being supported without error in the past. Aside #3- application change A recent app update likely has caused an increase in memory consumption. Aside #4 - usage change A Monday after a 4 day holiday weekend likely caused an increase in application usage. -- http://www.freelists.org/webpage/oracle-l