From oracle-l-bounce@freelists.org Tue Oct 18 12:34:24 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9IHYNVJ027109 for ; Tue, 18 Oct 2005 12:34:23 -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 j9IHYJvX027091 for ; Tue, 18 Oct 2005 12:34:19 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 62266207957; Tue, 18 Oct 2005 12:34:15 -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 11379-03; Tue, 18 Oct 2005 12:34:15 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DD7BF207749; Tue, 18 Oct 2005 12:34:14 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5D409.DED7F048" Subject: Finding Oracle session memory used? Date: Tue, 18 Oct 2005 13:32:10 -0400 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Finding Oracle session memory used? Thread-Index: AcXUCd7TBMLp1uoyRqawgGD5hA34aw== From: "Marquez, Chris" To: X-archive-position: 27146 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: cmarquez@collegeboard.org Precedence: normal Reply-To: cmarquez@collegeboard.org 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.1 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 ------_=_NextPart_001_01C5D409.DED7F048 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I see these GUI tools and they show complete total memory used for each = session...where do they get it? Anybody have a good script or doc showing the total current memory = consumed by an Oracle session. I believe that scripts I have are out dated or incomplete? Maybe there is even a better single view the has all this stuff now? I have an old shell script that calculates this from the OS, but seems = debatable. I have a sql script that looks at v$sesstat, v$statname and others to = find 'session uga memory max'...but I'm not sure there is not more? My script shows this...again via; = ...TO_CHAR(ROUND(value/1024),99999999)...from v$sesstat, v$statname,...) USERNAME STATUS MACHINE MEMORY =20 ------------- ---------- -------------------- --------------- SCOTT ACTIVE HQ-OFFICEPC 15784 KB Thanks, Chris Marquez Oracle DBA ------_=_NextPart_001_01C5D409.DED7F048 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Finding Oracle session memory used?

I see these GUI tools and they show complete total = memory used for each session...where do they get it?

Anybody have a good script or doc showing the total current memory = consumed by an Oracle session.
I believe that scripts I have are out dated or incomplete?
Maybe there is even a better single view the has all this stuff now?

I have an old shell script that calculates this from the OS, but seems = debatable.
I have a sql script that looks at v$sesstat, v$statname and others to = find 'session uga memory max'...but I'm not sure there is not more?

My script shows this...again via;  = ...TO_CHAR(ROUND(value/1024),99999999)...from v$sesstat, = v$statname,...)

USERNAME      STATUS     = MACHINE           =    = MEMORY         
------------- ---------- -------------------- ---------------
SCOTT         = ACTIVE     = HQ-OFFICEPC          &n= bsp;   15784 KB

Thanks,

Chris Marquez
Oracle DBA

------_=_NextPart_001_01C5D409.DED7F048-- -- http://www.freelists.org/webpage/oracle-l