Data Pump Tuning Strategies

LOGTIME Parameter

The LOGTIME parameter determines if timestamps should be included in the output messages from the expdp and impdp utilities.

LOGTIME=[NONE | STATUS | LOGFILE | ALL]

The allowable values are explained below.

• NONE : The default value, which indicates that no timestamps should be included in the output, making the output look similar to that of previous versions.
• STATUS : Timestamps are included in output to the console, but not in the associated log file.
• LOGFILE : Timestamps are included in output to the log file, but not in the associated console messages.
• ALL : Timestamps are included in output to the log file and console.

expdp scott/tiger tables=emp directory=test_dir dumpfile=emp.dmp logfile=expdp_emp.log logtime=all

METRICS Parameter

A very simple performance quantification technique is to use the METRICS=Y expdp option.  With the METRICS=Y option datapump helps quantify exactly how long Data Pump spends in each section and prints a line "Completed ..... in X seconds" after each section. 

 For example:

$ expdp dumpfile=DATA_PUMP_DIR:demo.dmp nologfile=y metrics=y userid=scott/tiger

So, next time when you want to talk  to investigate data pump performance  you specify METRICS=Y and LOGTIME=ALL for your data pump jobs.

 Amazingly useful METRICS=Y and LOGTIME=ALL these parameters while troubleshooting datapump Performance.