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 ** 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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 ---------------------------------------------- This space is available for rent.