From oracle-l-bounce@freelists.org Thu Aug 5 11:46:42 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i75GkgH10193 for ; Thu, 5 Aug 2004 11:46:42 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i75GkgI10187 for ; Thu, 5 Aug 2004 11:46:42 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CA53472C885; Thu, 5 Aug 2004 11:37:40 -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 24443-05; Thu, 5 Aug 2004 11:37:40 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 95FD072C87D; Thu, 5 Aug 2004 11:37:39 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 05 Aug 2004 11:36:09 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 329BC72C59C for ; Thu, 5 Aug 2004 11:36:09 -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 22424-93 for ; Thu, 5 Aug 2004 11:36:08 -0500 (EST) Received: from cwysmtp02.acxiom.com (cwysmtp02.acxiom.com [198.160.100.129]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 91B0172C57A for ; Thu, 5 Aug 2004 11:36:08 -0500 (EST) Received: from relay.Corp.Acxiom.net (unverified [139.61.199.171]) by cwysmtp02.acxiom.com (Content Technologies SMTPRS 4.3.12) with ESMTP id for ; Thu, 5 Aug 2004 11:50:47 -0500 Received: from dngmsc01.Corp.Acxiom.net (unverified [10.76.40.237]) by relay.Corp.Acxiom.net (Content Technologies SMTPRS 4.3.12) with ESMTP id for ; Thu, 5 Aug 2004 11:50:46 -0500 Received: by dngmsc01.dg.acxiom.com with Internet Mail Service (5.5.2657.72) id ; Thu, 5 Aug 2004 11:50:46 -0500 Message-ID: <433A07749711884D8032B6A0AB115262C2BCFC@conmsx07.corp.acxiom.net> From: Wolfson Larry - lwolfs To: "'oracle-l@freelists.org'" Subject: RE: max proccesses connected to database Date: Thu, 5 Aug 2004 11:25:35 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-type: text/plain X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 6952 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: lawrence.wolfson@acxiom.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Here's a ksh script and sql we use to list the resource activity Larry $DBS where we keep our source $OR Oracle Reports ENV.$DB all environment variables if we ever have to make a change we only update one script DB a table that only has a few columns name(Database name), server(server name) etc. We don't use V$DATABASE because too many would show PROD instead of BOST, NWYK,KNOX,CHGO,DALL,ATLA,JACK,HOUS,SFRN,PHNX etc. #!/bin/ksh # Written by Lawrence Wolfson 07/25/02 # DB VRL LIST FOR High Water Marks # HWMs () ( . $DBS/ENV.$DB print " @$DBS/VRL EXIT" |\ sqlplus "/ as sysdba" mv $OR/VRL.$ORACLE_SID $OR/VRL.$ORACLE_SID.$DT3 ) DT3=`date +%y%j%H%M` DBS={your source} cd $DBS #for DB in `cut -f 1 -d':' /var/opt/oracle/oratab` #multiple SIDs # do # HWMs $DB DB=PROD HWMs $DB # done --Written by Lawrence Wolfson 05/29/01 --V$RESOURCE_LIMIT SET ECHO ON SET LINESIZE 256 SET PAGESIZE 1000 COL RESOURCES FOR A24 COL CURR FOR 999,999 COL MAX FOR 999,999 SPOOL $OR/VRL.$ORACLE_SID SELECT name ,RESOURCE_NAME RESOURCES ,CURRENT_UTILIZATION CURR ,MAX_UTILIZATION MAX ,INITIAL_ALLOCATION INITIALLY ,LIMIT_VALUE ,to_char(SYSDATE,'mm/dd/yy hh24:mi:ss') timestamp FROM V$RESOURCE_LIMIT ,DB ; SPOOL OFF -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of J.Velikanovs@alise.lv Sent: Thursday, August 05, 2004 11:20 AM To: oracle-l@freelists.org Subject: Re: max proccesses connected to database I am not sure you are asking for, may be this can be usefull for you SYS:XXX> select * from V$LICENSE; SESSIONS_MAX SESSIONS_WARNING SESSIONS_CURRENT SESSIONS_HIGHWATER USERS_MAX ------------ ---------------- ---------------- ------------------ ---------- 0 0 5 14 0 SYS:XXX> Alert log, as well =========== Shutting down instance (abort) License high water mark = 502 Instance terminated by USER, pid = 19050 Tue Jun 1 13:25:09 2004 Starting ORACLE instance (normal) =========== Jurijs +371 9268222 (+2 GMT) ============================================ Thank you for teaching me. http://otn.oracle.com/ocm/jvelikanovs.html "Juan Carlos Reyes Pacheco" Sent by: oracle-l-bounce@freelists.org 05.08.2004 18:55 Please respond to oracle-l To: cc: Subject: max proccesses connected to database Sorry I don't remember and I could'nt find in documentation and I need urgent. how can I get the statistics about the maximum processes conected to the database Thanks Juan Carlos Reyes Pacheco OCP ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ********************************************************************** The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------