RE: ** SPAM scored: Low **RE: Re-setting V$tables

Nah, this creates objects in DB namely a DB link and a package, you fresh meat.  

Lot of customer, these SOx days, will shoot you with a riot gun if you do this, it is not usable on production DB.  

I know site were it takes 3 weeks for an 'ultra fast emergency' administration allowance procedure
for such a big deal that creating a GTT. Can't image if I ask for a procedure or worse a DBlink.  

Bp

From: Tanel Poder [mailto:tanel.poder.003_at_mail.ee] Sent: Wednesday, 11 October, 2006 1:29 PM To: Polarski, Bernard; oracle-l_at_freelists.org Subject: ** SPAM scored: Low **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