| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Simulate AWR like repository in 9i
Raj,
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).
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?)
Hth,
John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)
Co-Author: Oracle Database 10g Insider Solutions http://www.samspublishing.com/title/0672327910
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_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.
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.
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.
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.
TIA
Raj
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Dec 13 2005 - 15:42:00 CST
 |
 |