Data Pump Expdp Impdp Metrics=Y Undocumented Parameter

This is an undocumented parameter for the data pump. The Matrics=y option will log the list of objects exported or imported in each category and the time taken for each category objects. All the details will be logged in the logfile. See an example below.

$ expdp dumpfile=tab_exp.dmp logfile=tab_exp.log schemas=sthomas metrics=Y directory=exp_dir

Export: Release 11.2.0.3.0 - Production on Thu Feb 13 14:13:37 2014 

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Username: / as sysdba 

Connected to: Oracle Database 11g Release 11.2.0.3.0 - 64bit Production

Starting "SYS"."SYS_EXPORT_SCHEMA_01":  /******** AS SYSDBA dumpfile=tab_exp.dmp                    logfile=tab_exp.log schemas=sthomas metrics=Y directory=exp_dir

Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 64.18 MB

Processing object type SCHEMA_EXPORT/USER

     Completed 1 USER objects in 0 seconds

Processing object type SCHEMA_EXPORT/SYSTEM_GRANT

     Completed 1 SYSTEM_GRANT objects in 0 seconds

Processing object type SCHEMA_EXPORT/ROLE_GRANT

     Completed 1 ROLE_GRANT objects in 0 seconds

Processing object type SCHEMA_EXPORT/DEFAULT_ROLE

     Completed 1 DEFAULT_ROLE objects in 0 seconds

Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA

     Completed 1 TABLESPACE_QUOTA objects in 2 seconds

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

     Completed 1 PROCACT_SCHEMA objects in 7 seconds

Processing object type SCHEMA_EXPORT/TABLE/TABLE

     Completed 6 TABLE objects in 18 seconds

Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT

     Completed 1 OBJECT_GRANT objects in 1 seconds

Processing object type SCHEMA_EXPORT/TABLE/COMMENT

     Completed 2 COMMENT objects in 1 seconds

Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE

     Completed 1 PROCEDURE objects in 1 seconds

Processing object type SCHEMA_EXPORT/PROCEDURE/GRANT/OWNER_GRANT/OBJECT_GRANT

     Completed 1 OBJECT_GRANT objects in 0 seconds

Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE

     Completed 1 ALTER_PROCEDURE objects in 2 seconds

Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX

     Completed 2 INDEX objects in 2 seconds

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

     Completed 1 CONSTRAINT objects in 0 seconds

Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

     Completed 2 INDEX_STATISTICS objects in 4 seconds

Processing object type SCHEMA_EXPORT/VIEW/VIEW

     Completed 3 VIEW objects in 5 seconds

Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

     Completed 5 TABLE_STATISTICS objects in 24 seconds

. . exported "STHOMAS"."HINT_TEST"                       52.38 MB  542392 rows

. . exported "STHOMAS"."OBJ_LIST"                        905.3 KB    9999 rows

. . exported "STHOMAS"."DEPT"                            6.351 KB       4 rows

. . exported "STHOMAS"."MV_DEPT"                         5.085 KB       4 rows

. . exported "STHOMAS"."dept"                            5.921 KB       3 rows

Master table "SYS"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded

***********************************************************************

Dump file set for SYS.SYS_EXPORT_SCHEMA_01 is:

  /u07/exp_dir/tab_exp.dmp

Job "SYS"."SYS_EXPORT_SCHEMA_01" successfully completed at 14:14:59
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google