Simulate AWR like repository in 9i

From: rjamya <rjamya_at_gmail.com>
Date: Tue, 13 Dec 2005 06:06:21 -0500
Message-ID: <9177895d0512130306y4db5baa3reafa0a040a4461ee@mail.gmail.com>

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.
--

http://www.freelists.org/webpage/oracle-l Received on Tue Dec 13 2005 - 05:06:30 CST