Description:-
When METRICS=YES is used, the number of objects and the elapsed time are recorded in the Data Pump log file.
METRICS=[YES | NO]
We have additional information can be obtained about the number of objects that were processed and the time it took for processing them.
The METRICS parameter does not create any additional trace files. Instead,
the extra details are logged in the logfile of the Export Data Pump or Import Data Pump job.
[oracle@prod101 ~]$ expdp scott/tiger directory=test_dir dumpfile=oradbs.dmp logfile=oradbs.log tables=oracledbwr metrics=y Export: Release 18.0.0.0.0 - Production on Fri Aug 24 23:48:28 2018 Version 18.3.0.0.0 Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production Starting "SCOTT"."SYS_EXPORT_TABLE_01": scott/******** directory=test_dir dumpfile=oradbs.dmp logfile=oradbs.log tables=oracledbwr metrics=y W-1 Startup took 0 seconds W-1 Processing object type TABLE_EXPORT/TABLE/TABLE_DATA W-1 Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS W-1 Completed 1 INDEX_STATISTICS objects in 1 seconds W-1 Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS W-1 Completed 1 TABLE_STATISTICS objects in 0 seconds W-1 Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER W-1 Completed 1 MARKER objects in 7 seconds W-1 Processing object type TABLE_EXPORT/TABLE/TABLE W-1 Completed 1 TABLE objects in 4 seconds W-1 Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX W-1 Completed 1 INDEX objects in 0 seconds W-1 . . exported "SCOTT"."ORACLEDBWR" 3.067 MB 458752 rows in .9999999999999999999999999999999999999996 seconds using direct_path W-1 Completed 1 TABLE_EXPORT/TABLE/TABLE_DATA objects in 1 seconds W-1 Master table "SCOTT"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded ****************************************************************************** Dump file set for SCOTT.SYS_EXPORT_TABLE_01 is: /u01/app/oracle/datapump/oradbs.dmp Job "SCOTT"."SYS_EXPORT_TABLE_01" successfully completed at Fri Aug 24 23:49:00 2018 elapsed 0 00:00:25
Catch Me On:- Hariprasath Rajaram
Telegram:https://t.me/joinchat/I_f4DhGF_Zifr9YZvvMkRg
LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page: https://www.facebook.com/dbahariprasath/?
Twitter: https://twitter.com/hariprasathdba
