RE: Is this Needed?

Yes I feel sorry for you.
Like Thomas said, without information regarding tablespace/datafile/disk/hardware reconfiguration this is are wishful thinking. Man, I don't miss *battles* like these...you will basically have to teach someone something they don't want to hear.

Good Luck,

Chris Marquez
Oracle DBA

-----Original Message-----

From: oracle-l-bounce_at_freelists.org on behalf of Mercadante, Thomas F (LABOR) Sent: Wed 10/26/2005 10:51 AM
To: dofreeman_at_state.pa.us; Oracle-L (E-mail) Subject: RE: Is this Needed?  

Yes. Total waste of time.

Unless they are moving mount points around. But even then, you could use "alter table move" commands.

Somebody read an old document on the web.

Here is a chance for you to be a soothsayer. Tell everyone that this will not solve anything, that they should be spending more time on tracing slow transactions to see what the *real* problem is.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Freeman, Donald Sent: Wednesday, October 26, 2005 10:41 AM To: Oracle-L (E-mail)
Subject: Is this Needed?

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?

Don Freeman
Database Administrator 1
Bureau of Information Technology
Pennsylvania Department of Health
717-783-8095 Ext 337

--

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

--

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

--

http://www.freelists.org/webpage/oracle-l Received on Wed Oct 26 2005 - 10:00:53 CDT