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@xxxxxxx] Sent: Wednesday, 11 October, 2006 1:29 PM To: Polarski, Bernard; oracle-l@xxxxxxxxxxxxx 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)