Simulate AWR like repository in 9i
- From: rjamya <rjamya@xxxxxxxxx>
- To: Oracle Discussion List <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 13 Dec 2005 06:06:21 -0500
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:
