 |
|
Oracle Tips by Burleson |
OCP Instructors Guide for
Oracle DBA Certification
Chapter 8 -
Miscellaneous Oracle Information
Full Database Exports
When executing full database Exports, use
CONSISTENT=Y to maintain a consistent view of the database. Oracle
will ensure that all tables are consistent to the time the export
utility started. Prevent "snapshot too old" messages by ensuring
sufficient rollback/undo segments are available.
Large Table Imports
Use commit=Y on imports to reduce the
chances of experiencing rollback/undo segment problems when
importing large tables. The commit=Y parameter specifies
whether Import should commit after each array insert. By default,
Import commits only after loading each table. If an error occurs,
Import will perform a rollback and continue with the next object.
Specifying commit=Y prevents rollback segments from growing
inordinately large and improves the performance of large imports.
Compressing Export
Output Files in UNIX
If you are concerned about the size of your
Export’s dump file, you can use the following commands to create an
Export dump file that is already compressed. Combining the Export
and compress processes overcomes the requirement of creating the
uncompressed dump file first and then compressing it later.
The above text is
an excerpt from:
OCP Instructors Guide for Oracle DBA Certification
A Study Guide to Advanced Oracle Certified Professional Database
Administration Techniques
ISBN 0-9744355-3-8
by Christopher T. Foot
http://www.rampant-books.com/book_2003_2_OCP_print.htm
 |
For more details and scripts, see my new book "
Oracle
Tuning: The Definitive Reference", over 900 pages
of BC's favorite tuning tips & scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot. |
|
