«

»

Jul 29

Oracle EXPDP metrics

Is your Oracle EXPDP performing poorly?  Oracle has included an undocumented option called METRICS in the EXPDP command.  Simply add METRICS=Y to your EXPDP command line, and you will get performance data in your logfile.

 

;;;
Export: Release 11.2.0.4.0 – Production on Thu Jul 28 20:24:45 2016

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
Starting “SYS”.”SYS_EXPORT_FULL_01″: “/******** AS SYSDBA” directory=oraexports dumpfile=test.dmp logfile=test.log full=y metrics=y
Startup took 1 seconds
Estimate in progress using BLOCKS method…
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Estimated 705 TABLE_DATA objects in 4 seconds
Total estimation using BLOCKS method: 3.691 GB
Processing object type DATABASE_EXPORT/TABLESPACE
Completed 18 TABLESPACE objects in 2 seconds
Processing object type DATABASE_EXPORT/PROFILE
Completed 2 PROFILE objects in 0 seconds

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>