From oracle-l-bounce@freelists.org Thu Jul 8 22:23:56 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i693Nfo28409 for ; Thu, 8 Jul 2004 22:23:51 -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 i693NU628393 for ; Thu, 8 Jul 2004 22:23:40 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 81A4972C46E; Thu, 8 Jul 2004 22:04:41 -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 21544-36; Thu, 8 Jul 2004 22:04:41 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DA0BC72C380; Thu, 8 Jul 2004 22:04:40 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 08 Jul 2004 22:03:19 -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 04B3172C2A1 for ; Thu, 8 Jul 2004 22:03:19 -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 19883-96 for ; Thu, 8 Jul 2004 22:03:18 -0500 (EST) Received: from rediffmail.com (unknown [202.54.124.179]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id B76FA72C230 for ; Thu, 8 Jul 2004 22:03:17 -0500 (EST) Received: (qmail 3133 invoked by uid 510); 9 Jul 2004 03:27:16 -0000 Date: 9 Jul 2004 03:27:16 -0000 Message-ID: <20040709032716.3132.qmail@webmail10.rediffmail.com> Received: from unknown (221.191.65.144) by rediffmail.com via HTTP; 09 jul 2004 03:27:15 -0000 MIME-Version: 1.0 From: "Prem Khanna J" To: "Oracle-L" Subject: script to calculate memory usage by oracle processes in AIX ? Content-type: text/plain X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 4727 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: premj@rediffmail.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Hi All, the env is oracle 9.2.0.4/AIX5.2 in order to calculate the memory used by each oracle server process on AIX,i am using the following method (as said in a metalink doc 123754.1): $ps -ef | grep oracledev01 | grep -v grep | awk '{print $2}' this gives me the PID of all oracle server process.around 60 in my case.here dev01 is my ORACLE_SID. Then... $ps v <2023464> | awk '{print $7-$10} this gives me the memory used by one oracle server process. i have to replace the PID within <> above and do it for 60 processes. so i made it like $ps -ef | grep oracledev01 | grep -v grep | awk '{print $2}' | xargs ps v <2023464> | awk '{print $7-$10} but this just gives the output for the first process only and not all 60 processes .excuse me for my poor scripting.i am new to it.How do i do this in a small shell/perl script ? can someone help me ? Regards, Prem. ---------------------------------------------------------------- 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 -----------------------------------------------------------------