I am in the middle of a performance tuning exercise. Unfortunately, I just realized that I accidentally excluded 40 statements from my baseline. Therefore, I am restoring the database to baseline mode, which means a lot of things including the removal of a bunch of newly-created histograms. What is the preferred method of eliminating these beasts? :)

Of course, once I'm done re-running my baseline, I need to re-create these same histograms (and everything else, of course). Is there any way to do this short of re-building them? Note that we are using DBMS_STAT to flip the stats between the baseline and current. Do histograms play into this at all?

Now, the restrictions are that I am a designer/developer and not a DBA, nor do I have DBA rights. I also do not have, nor care to have, any knowledge of or access to Unix :), so this must all be done within SQL. I can manually work around all of these issues, so I'm not sweating this, but I am always looking for the 'better way'.

Thanks in advance,

- Chris