Re: Is this Needed?

  • From: Mladen Gogala <gogala@xxxxxxxxxxxxx>
  • To: dofreeman@xxxxxxxxxxx
  • Date: Wed, 26 Oct 2005 19:06:49 +0000

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


Other related posts: