RE: Re-setting V$tables

This has been done by Kyle Hailey long time ago, it's the ASH simulator (and has nothing to do with AWR):  

http://oraperf.sourceforge.net/ashmon/simulating_ash.html  

Tanel.

For those interested, keep an eye on http://www.smenu.org/smenu_owi.htm Should not be long to implement this. I will make also a stand alone version of the sampler so people crying on the $$ of AWR or version 8i and 9i, can have a diagnostic of the oracle wait interface for free. and last (that's the more painful, update the doc)  

--
http://www.freelists.org/webpage/oracle-l