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
Received on Wed Oct 26 2005 - 09:43:11 CDT
