RE: Is this Needed?
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <dofreeman@xxxxxxxxxxx>, "Oracle-L (E-mail)" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 26 Oct 2005 10:51:36 -0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
