Re: Export resource usage

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 24 Apr 2006 13:26:53 -0700
Message-ID: <1145910413.139305.188250@t31g2000cwb.googlegroups.com>

Exp is just another reader. If the disk IO system is not being taxed then you will probably not notice the export except that while reading tables subject to heavy DML activity the export task could have to perform a lot of consistent read gets requiring rollback segment lookups or even fail with an ORA-01555 error. Most likely other sessions will not notice the effect except as I mentioned if your disk IO system is near its sustainable IO capacity.

Generally speaking you do want to take the exports during periods of low usage. The lower the usage the less likely that data between different tables is inconsistent with each other from an application point of view.

HTH -- Mark D Powell -- Received on Mon Apr 24 2006 - 15:26:53 CDT