Re: Is this Needed?

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


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