Oracle export and import utilities - Explain how to improve Import/Export
performance posted by Babu
Kunwar
Explain how to improve Import/Export performance?
We can improve efficiency by taking care of certain things:
-
Minimize I/O argument by placing the export dump file on a disk separate from
the disk containing the data files.
-
Break the export into smaller exports, and then run each export in parallel.
-
Export to a high-speed disk.
-
Don't back up read-only tablespaces. Also, make sure that the read-only
tablespace wasn't read-write during the last export and has switched to
read-only since that time.
-
*Schedule the export during periods of the least database activity.
-
Make sure that the frequency of performing an export is proper. In other words,
if not much activity is going on in the database, you're better off exporting
less frequently.
More links
What is the Oracle Web Cache?
Difference between the Database and Web Cache
Explain how to install and configure the Web Cache
Explain how to stop and start the Web Cache...............
|
