From oracle-l-bounce@freelists.org Fri Oct 28 03:31:18 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9S8VHaI012863 for ; Fri, 28 Oct 2005 03:31:17 -0500 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 j9S8V4vX012792 for ; Fri, 28 Oct 2005 03:31:14 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 126E121177A; Fri, 28 Oct 2005 03:30:56 -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 26103-01; Fri, 28 Oct 2005 03:30:55 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7F2AE211615; Fri, 28 Oct 2005 03:30:55 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 28 Oct 2005 03:29:01 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E60C8211493 for ; Fri, 28 Oct 2005 03:29:00 -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 25885-03 for ; Fri, 28 Oct 2005 03:29:00 -0500 (EST) Received: from falcon.uce.ac.uk (falcon.uce.ac.uk [193.60.133.100]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A610A2113EB for ; Fri, 28 Oct 2005 03:29:00 -0500 (EST) Received: from exchangeb.staff.uce.ac.uk ([10.255.50.153]) by falcon.uce.ac.uk with esmtp (Exim 4.24) id 1EVPbf-0002mY-5d for oracle-l@freelists.org; Fri, 28 Oct 2005 09:28:59 +0100 X-MimeOLE: Produced By Microsoft Exchange V6.0.6603.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5DB99.A4A84C2F" Subject: Determining License High Water Mark without shutdown Date: Fri, 28 Oct 2005 09:28:58 +0100 Message-ID: <14C5F9616FF43F479F67E41A1DF4D94A050FF06E@exchangeb.staff.uce.ac.uk> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Determining License High Water Mark without shutdown Thread-Index: AcXa/0n/GuM/vm7jRWCNND59of63mwAmVIyw From: "Paul Vincent" To: UCE-Spam-Score: -4.2 (----) X-archive-position: 27717 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Paul.Vincent@uce.ac.uk Precedence: normal Reply-To: Paul.Vincent@uce.ac.uk 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=-4.7 required=5.0 tests=BAYES_00,HTML_FONTCOLOR_BLUE, HTML_MESSAGE autolearn=no version=2.63 ------_=_NextPart_001_01C5DB99.A4A84C2F Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Recently we needed to increase the PROCESSES parameter due to a major increase in system usage. Rather than wait for a spate of reported ORA-00020 messages, I'm keeping an eye on the "License High Water Mark" entry in the alert log each time the instance is shut down, so I can increase PROCESSES again if the demand starts to approach the limit again. The problem is, this message only appears at shutdown, which isn't very helpful. What I'd like to be able to do is, at any time, see what the current High Water Mark is. Now, honest folks, I've RTFM'ed for all I'm worth, but can't find the relevant system view that contains this information. I should emphasise that I'm not looking for the current number of sessions at a moment in time, I'm looking for the high water mark figure since the last time the instance was started up.=20 =20 Can anyone point me in the right direction, please, or let me know if the information *can't* be determined other than at shutdown? =20 Thanks, =20 Paul Vincent DBA UCE Birmingham ------_=_NextPart_001_01C5DB99.A4A84C2F Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
Recently we needed to increase the PROCESSES = parameter due=20 to a major increase in system usage. Rather than wait for a spate of = reported=20 ORA-00020 messages, I'm keeping an eye on the "License High Water Mark" = entry in=20 the alert log each time the instance is shut down, so I can increase = PROCESSES=20 again if the demand starts to approach the limit again. The problem is, = this=20 message only appears at shutdown, which isn't very helpful. What I'd = like to be=20 able to do is, at any time, see what the current High Water Mark is. = Now, honest=20 folks, I've RTFM'ed for all I'm worth, but can't find the relevant = system view=20 that contains this information. I should emphasise that I'm not looking = for the=20 current number of sessions at a moment in time, I'm looking for the high = water=20 mark figure since the last time the instance was started up.=20
 
Can anyone point me in the right direction, = please, or let=20 me know if the information *can't* be determined other than at=20 shutdown?
 
Thanks,
 
Paul Vincent
DBA
UCE = Birmingham
------_=_NextPart_001_01C5DB99.A4A84C2F-- -- http://www.freelists.org/webpage/oracle-l