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.

Other related posts: