On 10/26/2005 10:40:58 AM, Freeman, Donald wrote: > I just received a notice from our technical team leader that we were going to > schedule > a 'refresh' on our transactional database in order to improve performance. > They are going to > truncate and reimport the production schema. Is this technique useful for a > 9i database? > I'm thinking that in earlier versions of Oracle it might have been helpful > but on the other hand > I don't see any discussion of this on any board that I am monitoring. Is > this a waste of time? There is one thing you can do: ask your technical team leader what exactly does he or she want to accomplish by doing that? From a point of view of EMC salesperson, this is very useful excercise indeed, because he can sell you faster hardware just in time to get a Christmas bonus. I somehow doubt that motives for such a drastic action include sheer kindness that the project involves helping the poor EMC sales force rebuild their swimming pools. -- Mladen Gogala http://www.mgogala.com -- //www.freelists.org/webpage/oracle-l