From oracle-l-bounce@freelists.org Tue Dec 13 15:42:00 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id jBDLg0wA024785 for ; Tue, 13 Dec 2005 15:42:00 -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 jBDLg0AX024778 for ; Tue, 13 Dec 2005 15:42:00 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7A6E72556E2; Tue, 13 Dec 2005 16:41: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 08262-08; Tue, 13 Dec 2005 16:41:56 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E617D2556CE; Tue, 13 Dec 2005 16:41:55 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 13 Dec 2005 16:41:54 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 71FB32556DE for ; Tue, 13 Dec 2005 16:41:54 -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 08262-05 for ; Tue, 13 Dec 2005 16:41:54 -0500 (EST) Received: from usscmail7.hds.com (usscmail7.hds.com [63.74.235.18]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F31AE2556D8 for ; Tue, 13 Dec 2005 16:41:53 -0500 (EST) Received: from mail.hds.com (usscmail8 [10.1.6.229]) by usscmail7.hds.com (8.11.7p1+Sun/8.11.5) with ESMTP id jBDLfrG05367; Tue, 13 Dec 2005 13:41:53 -0800 (PST) Received: from usscceb102.corp.hds.com (USSCCNETSLB08-VLAN4.hds.com [10.1.6.68]) by mail.hds.com (8.11.5-p0-rfc19719/8.11.5) with ESMTP id jBDLfqu00560; Tue, 13 Dec 2005 13:41:52 -0800 (PST) Received: from USSCCEVS101.corp.hds.com ([10.1.52.224]) by usscceb102.corp.hds.com with Microsoft SMTPSVC(6.0.3790.1830); Tue, 13 Dec 2005 13:41:53 -0800 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_01C6002E.0771EEBD" Subject: RE: Simulate AWR like repository in 9i Date: Tue, 13 Dec 2005 13:41:52 -0800 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Simulate AWR like repository in 9i Thread-Index: AcX/1YivnIe1A1++Tza8+/qhCyLIaAAVgnSg From: "John Kanagaraj" To: , "Oracle Discussion List" X-OriginalArrivalTime: 13 Dec 2005 21:41:53.0057 (UTC) FILETIME=[08129910:01C6002E] X-archive-position: 29134 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: john.kanagaraj@hds.com Precedence: normal Reply-To: john.kanagaraj@hds.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: Not scanned: please contact your Internet E-Mail Service Provider for details X-MailScanner-From: oracle-l-bounce@freelists.org ------_=_NextPart_001_01C6002E.0771EEBD Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Raj, =20 This isn't a bad idea at all. AWR (among other things) actually collects both System level information (sorta like STATSPACK) for AWR/ADDM reporting and Session level information by persisting the much more granular ASH data. The MMON and MMNL processes (again among other things) perform the 'light' part of the collection for both ASH and AWR and (I believe) sample SGA directly for ASH information. There was an article on IOUG's SELECT mag on performing direct SGA access and I think there is something out at Kyle 'X$' Hailey's website (not sure if this is still around). You should be able to adapt from there (let me know if you can't get the code and I will dig around for it). =20 I am actually working on developing this idea of 'backporting' as part of a paper for the upcoming Collaborate '06 conference, so you are not alone in having this 'bad idea' ;-) (Has anyone heard back about paper selections for '06?) =20 Hth, John Kanagaraj <>< DB Soft Inc Phone: 408-970-7002 (W) =20 Co-Author: Oracle Database 10g Insider Solutions http://www.samspublishing.com/title/0672327910 =20 ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** ________________________________ From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of rjamya Sent: Tuesday, December 13, 2005 3:06 AM To: Oracle Discussion List Subject: Simulate AWR like repository in 9i I may have this requirement to implement something that captures session details and sessions waits at very short intervals in a 9204 database. AWR kinda does that in 10g, but this is no 10g.=20 I am wondering what might be the lightest process that I can run maybe at a minute interval? Too many and too frequent selects against gv$ are not good, and I understand that. But I have a feeling that this requirement is coming down the line.=20 Question for experts ... if write a really (well as light as I can) process to get info from x$ksusecst (for waits) and x$ksuse (for session), what should I look for as potential problems (any specific latches?). Oh yeah and this will be running on a RAC system.=20 Feel free to tell me that this is a bad idea, but if the request comes down I will then use those arguments to say why we shouldn't do it.=20 TIA Raj=20 ----------------------------------------------=20 This space is available for rent. ------_=_NextPart_001_01C6002E.0771EEBD Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
Raj,
 
This isn't a bad idea at all. AWR (among other = things)=20 actually collects both System level information (sorta like STATSPACK) = for=20 AWR/ADDM reporting and Session level information by persisting the much = more=20 granular ASH data. The MMON and MMNL processes (again among other = things)=20 perform the 'light' part of the collection for both ASH and AWR and (I = believe)=20 sample SGA directly for ASH information. There was an article on IOUG's = SELECT=20 mag on performing direct SGA access and I think there is something out = at Kyle=20 'X$' Hailey's website (not sure if this is still around). You should be = able to=20 adapt from there (let me know if you can't get the code and I will dig = around=20 for it).
 
I am actually working on developing this idea = of=20 'backporting' as part of a paper for the upcoming Collaborate '06 = conference, so=20 you are not alone in having this 'bad idea' ;-) (Has anyone heard back = about=20 paper selections for '06?)
 
Hth,
John Kanagaraj = <><
DB Soft=20 Inc
Phone: 408-970-7002 (W)
 
Co-Author: Oracle Database = 10g Insider=20 Solutions http://www.samspu= blishing.com/title/0672327910
 
** The opinions and facts = contained in=20 this message are entirely mine and do not reflect those of my employer = or=20 customers **


From: oracle-l-bounce@freelists.org=20 [mailto:oracle-l-bounce@freelists.org] On Behalf Of=20 rjamya
Sent: Tuesday, December 13, 2005 3:06 = AM
To:=20 Oracle Discussion List
Subject: Simulate AWR like repository = in=20 9i

I may have this requirement to implement something that = captures=20 session details and sessions waits at very short intervals in a 9204 = database.=20 AWR kinda does that in 10g, but this is no 10g.

I am wondering = what=20 might be the lightest process that I can run maybe at a minute interval? = Too=20 many and too frequent selects against gv$ are not good, and I understand = that.=20 But I have a feeling that this requirement is coming down the line.=20

Question for experts ... if write a really (well as light as I = can)=20 process to get info from x$ksusecst (for waits) and x$ksuse (for = session), what=20 should I look for as potential problems (any specific latches?). Oh yeah = and=20 this will be running on a RAC system.

Feel free to tell me that = this is=20 a bad idea, but if the request comes down I will then use those = arguments to say=20 why we shouldn't do it.
TIA
Raj 
-------------------------------------= ---------=20
This space is available for rent.
------_=_NextPart_001_01C6002E.0771EEBD-- -- http://www.freelists.org/webpage/oracle-l