Monday, February 18, 2013

Find Time Taken(Elapsed) by Objects Types During DATAPUMP Export



Some times we might have thought to know how much time the datapump utility took to export different Object Types.

We have a undocumented parameter in DATAPUMP to check how much it took to export different Object Types.

##########################
#  Task 
##########################

Find Time Taken(Elapsed) by Objects Types During DATAPUMP Export

##########################
#   Parameter  
##########################

 Metrics = Y 

##########################
## Solution
##########################

 Using Metrics Parameter in export, it will list out how much time elapsed to take export of specific object and this information will be recorded in the logfile used in the export command. 


No comments: