Maybe simulated ASH (SASH) can help you? Kyle Haily built this. Look at www.perfvision.com under tools. Best regards, Carel-Jan Engel === If you think education is expensive, try ignorance. (Derek Bok) === On Mon, 2008-02-04 at 21:21 -0700, Mark Brinsmead wrote: > ASH? Perhaps you mean AWR. > > No matter. Either way, you require licenses for the Oracle > Diagnostics Pack and/or Oracle Tuning Pack (both, probably) in > order to access ASH / AWR views. Once you have these licenses, > home-grown performance monitoring solutions might be kind of > pointless. :-) > > If you *really* need to sample this data that frequently, you might be > able to find a way to do it by writing a (C) program that directly > attaches to your SGA. This will be tough, though, if you have to > support a variety of platforms and releases... > > Is it really *necessary* to sample every 10 seconds? You could reduce > the CPU cost for your monitoring by (perhaps much) more than 90% > simply by sampling every 2 minutes instead. > <snip> > -- > Cheers, > -- Mark Brinsmead > Senior DBA, > The Pythian Group > http://www.pythian.com/blogs > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is > believed to be clean.