METRICS=y prints information about number of objects with elapsed time.
You have to add <METRICS=y> parameter in expdp command. If you do not specify the METRICS option, then the default is <METRICS=N>.
#Execute below command with <METRICS=y> option. C:\Windows\System32>expdp directory=DIR_TEST full=y dumpfile=FULL_DB.dmp logfile=FULL_DB.log METRICS=y Export: Release 19.0.0.0.0 - Production on Sat Mar 16 01:15:38 2024 Version 19.16.0.0.0 Copyright (c) 1982, 2022, Oracle and/or its affiliates. All rights reserved. Username: test Password: Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Starting "TEST"."SYS_EXPORT_FULL_01": test/******** directory=DIR_TEST full=y dumpfile=FULL_DB.dmp logfile=FULL_DB.log METRICS=y W-1 Startup took 0 seconds W-1 Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA W-1 Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA W-1 Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA W-1 Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA W-1 Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/INDEX_STATISTICS W-1 Completed 8 INDEX_STATISTICS objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS W-1 Completed 9 TABLE_STATISTICS objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/STATISTICS/MARKER W-1 Completed 1 MARKER objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKER W-1 Completed 1 MARKER objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER W-1 Completed 1 MARKER objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/TABLESPACE W-1 Completed 3 TABLESPACE objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/PROFILE W-1 Completed 1 PROFILE objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/SCHEMA/USER W-1 Completed 5 USER objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/ROLE W-1 Completed 1 ROLE objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/RADM_FPTM W-1 Completed 1 RADM_FPTM objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT W-1 Completed 7 PROC_SYSTEM_GRANT objects in 1 seconds W-1 Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT W-1 Completed 69 SYSTEM_GRANT objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT W-1 Completed 32 ROLE_GRANT objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE W-1 Completed 9 DEFAULT_ROLE objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/SCHEMA/ON_USER_GRANT W-1 Completed 6 ON_USER_GRANT objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA W-1 Completed 2 TABLESPACE_QUOTA objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/RESOURCE_COST W-1 Completed 1 RESOURCE_COST objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/SCHEMA/DB_LINK W-1 Completed 1 DB_LINK objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK W-1 Completed 1 TRUSTED_DB_LINK objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY W-1 Completed 2 DIRECTORY objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT W-1 Completed 4 OBJECT_GRANT objects in 1 seconds W-1 Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM W-1 Completed 2 PROCACT_SYSTEM objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ W-1 Completed 23 PROCOBJ objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM W-1 Completed 3 PROCACT_SYSTEM objects in 1 seconds W-1 Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA W-1 Completed 10 PROCACT_SCHEMA objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE W-1 Completed 1 TABLE objects in 3 seconds W-1 Processing object type DATABASE_EXPORT/EARLY_POST_INSTANCE_IMPCALLOUT/MARKER W-1 Completed 1 MARKER objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE W-1 Completed 63 TABLE objects in 31 seconds W-1 Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE W-1 Completed 18 TABLE objects in 16 seconds W-1 Processing object type DATABASE_EXPORT/NORMAL_POST_INSTANCE_IMPCALLOUT/MARKER W-1 Completed 1 MARKER objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE W-1 Completed 9 TABLE objects in 10 seconds W-1 Processing object type DATABASE_EXPORT/SCHEMA/TABLE/COMMENT W-1 Processing object type DATABASE_EXPORT/SCHEMA/VIEW/VIEW W-1 Completed 1 VIEW objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX W-1 Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT W-1 Completed 8 CONSTRAINT objects in 4 seconds W-1 Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/REF_CONSTRAINT W-1 Completed 4 REF_CONSTRAINT objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/FINAL_POST_INSTANCE_IMPCALLOUT/MARKER W-1 Completed 1 MARKER objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/AUDIT_UNIFIED/AUDIT_POLICY_ENABLE W-1 Completed 2 AUDIT_POLICY_ENABLE objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/POST_SYSTEM_IMPCALLOUT/MARKER W-1 Completed 1 MARKER objects in 0 seconds W-1 . . exported "SYS"."KU$_USER_MAPPING_VIEW" 6.117 KB 41 rows in 1 seconds using external_table W-1 . . exported "AUDSYS"."AUD$UNIFIED":"SYS_P181" 17.25 MB 10143 rows in 0 seconds using direct_path W-1 . . exported "AUDSYS"."AUD$UNIFIED":"SYS_P596" 77.67 KB 63 rows in 0 seconds using direct_path W-1 . . exported "AUDSYS"."AUD$UNIFIED":"SYS_P450" 58.56 KB 18 rows in 0 seconds using direct_path W-1 . . exported "AUDSYS"."AUD$UNIFIED":"SYS_P641" 56.96 KB 15 rows in 1 seconds using direct_path W-1 . . exported "SYSTEM"."REDO_DB" 25.59 KB 1 rows in 0 seconds using direct_path W-1 . . exported "WMSYS"."WM$WORKSPACES_TABLE$" 12.10 KB 1 rows in 0 seconds using direct_path W-1 . . exported "WMSYS"."WM$HINT_TABLE$" 9.984 KB 97 rows in 0 seconds using direct_path W-1 . . exported "LBACSYS"."OLS$INSTALLATIONS" 6.960 KB 2 rows in 0 seconds using direct_path W-1 . . exported "WMSYS"."WM$WORKSPACE_PRIV_TABLE$" 7.078 KB 11 rows in 0 seconds using direct_path W-1 . . exported "SYS"."DAM_CONFIG_PARAM$" 6.531 KB 14 rows in 0 seconds using direct_path W-1 . . exported "SYS"."TSDP_SUBPOL$" 6.328 KB 1 rows in 0 seconds using direct_path W-1 . . exported "WMSYS"."WM$NEXTVER_TABLE$" 6.375 KB 1 rows in 0 seconds using direct_path W-1 . . exported "LBACSYS"."OLS$PROPS" 6.234 KB 5 rows in 0 seconds using direct_path W-1 . . exported "WMSYS"."WM$ENV_VARS$" 6.015 KB 3 rows in 0 seconds using direct_path W-1 . . exported "SYS"."TSDP_PARAMETER$" 5.953 KB 1 rows in 0 seconds using direct_path W-1 . . exported "SYS"."TSDP_POLICY$" 5.921 KB 1 rows in 0 seconds using direct_path W-1 . . exported "WMSYS"."WM$VERSION_HIERARCHY_TABLE$" 5.984 KB 1 rows in 0 seconds using direct_path W-1 . . exported "WMSYS"."WM$EVENTS_INFO$" 5.812 KB 12 rows in 0 seconds using direct_path W-1 . . exported "LBACSYS"."OLS$AUDIT_ACTIONS" 5.757 KB 8 rows in 0 seconds using direct_path W-1 . . exported "LBACSYS"."OLS$DIP_EVENTS" 5.539 KB 2 rows in 0 seconds using direct_path W-1 . . exported "AUDSYS"."AUD$UNIFIED":"AUD_UNIFIED_P0" 50.95 KB 0 rows in 0 seconds using direct_path W-1 . . exported "LBACSYS"."OLS$AUDIT" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "LBACSYS"."OLS$COMPARTMENTS" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "LBACSYS"."OLS$DIP_DEBUG" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "LBACSYS"."OLS$GROUPS" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "LBACSYS"."OLS$LAB" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "LBACSYS"."OLS$LEVELS" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "LBACSYS"."OLS$POL" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "LBACSYS"."OLS$POLICY_ADMIN" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "LBACSYS"."OLS$POLS" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "LBACSYS"."OLS$POLT" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "LBACSYS"."OLS$PROFILE" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "LBACSYS"."OLS$PROFILES" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "LBACSYS"."OLS$PROG" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "LBACSYS"."OLS$SESSINFO" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "LBACSYS"."OLS$USER" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "LBACSYS"."OLS$USER_COMPARTMENTS" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "LBACSYS"."OLS$USER_GROUPS" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "LBACSYS"."OLS$USER_LEVELS" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "SYS"."AUD$" 23.46 KB 0 rows in 0 seconds using direct_path W-1 . . exported "SYS"."DAM_CLEANUP_EVENTS$" 7.187 KB 0 rows in 0 seconds using direct_path W-1 . . exported "SYS"."DAM_CLEANUP_JOBS$" 7.171 KB 0 rows in 0 seconds using direct_path W-1 . . exported "SYS"."TSDP_ASSOCIATION$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "SYS"."TSDP_CONDITION$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "SYS"."TSDP_FEATURE_POLICY$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "SYS"."TSDP_PROTECTION$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "SYS"."TSDP_SENSITIVE_DATA$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "SYS"."TSDP_SENSITIVE_TYPE$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "SYS"."TSDP_SOURCE$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "SYSTEM"."REDO_LOG" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "WMSYS"."WM$BATCH_COMPRESSIBLE_TABLES$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "WMSYS"."WM$CONSTRAINTS_TABLE$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "WMSYS"."WM$CONS_COLUMNS$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "WMSYS"."WM$LOCKROWS_INFO$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "WMSYS"."WM$MODIFIED_TABLES$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "WMSYS"."WM$MP_GRAPH_WORKSPACES_TABLE$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "WMSYS"."WM$MP_PARENT_WORKSPACES_TABLE$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "WMSYS"."WM$NESTED_COLUMNS_TABLE$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "WMSYS"."WM$RESOLVE_WORKSPACES_TABLE$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "WMSYS"."WM$RIC_LOCKING_TABLE$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "WMSYS"."WM$RIC_TABLE$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "WMSYS"."WM$RIC_TRIGGERS_TABLE$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "WMSYS"."WM$UDTRIG_DISPATCH_PROCS$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "WMSYS"."WM$UDTRIG_INFO$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "WMSYS"."WM$VERSION_TABLE$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "WMSYS"."WM$VT_ERRORS_TABLE$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "WMSYS"."WM$WORKSPACE_SAVEPOINTS_TABLE$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "MDSYS"."RDF_PARAM$" 6.515 KB 3 rows in 0 seconds using external_table W-1 . . exported "SYS"."AUDTAB$TBS$FOR_EXPORT" 5.953 KB 2 rows in 0 seconds using external_table W-1 . . exported "SYS"."DBA_SENSITIVE_DATA" 0 KB 0 rows in 0 seconds using external_table W-1 . . exported "SYS"."DBA_TSDP_POLICY_PROTECTION" 0 KB 0 rows in 0 seconds using external_table W-1 . . exported "SYS"."FGA_LOG$FOR_EXPORT" 0 KB 0 rows in 0 seconds using external_table W-1 . . exported "SYS"."NACL$_ACE_EXP" 0 KB 0 rows in 0 seconds using external_table W-1 . . exported "SYS"."NACL$_HOST_EXP" 6.976 KB 2 rows in 0 seconds using external_table W-1 . . exported "SYS"."NACL$_WALLET_EXP" 0 KB 0 rows in 0 seconds using external_table W-1 . . exported "SYS"."SQL$TEXT_DATAPUMP" 0 KB 0 rows in 0 seconds using external_table W-1 . . exported "SYS"."SQL$_DATAPUMP" 0 KB 0 rows in 0 seconds using external_table W-1 . . exported "SYS"."SQLOBJ$AUXDATA_DATAPUMP" 0 KB 0 rows in 0 seconds using external_table W-1 . . exported "SYS"."SQLOBJ$DATA_DATAPUMP" 0 KB 0 rows in 0 seconds using external_table W-1 . . exported "SYS"."SQLOBJ$PLAN_DATAPUMP" 0 KB 0 rows in 0 seconds using external_table W-1 . . exported "SYS"."SQLOBJ$_DATAPUMP" 0 KB 0 rows in 0 seconds using external_table W-1 . . exported "SYSTEM"."SCHEDULER_JOB_ARGS" 0 KB 0 rows in 0 seconds using external_table W-1 . . exported "SYSTEM"."SCHEDULER_PROGRAM_ARGS" 0 KB 0 rows in 0 seconds using external_table W-1 . . exported "WMSYS"."WM$EXP_MAP" 7.718 KB 3 rows in 2 seconds using external_table W-1 . . exported "WMSYS"."WM$METADATA_MAP" 0 KB 0 rows in 0 seconds using external_table W-1 . . exported "TEST"."DEPT" 6.531 KB 5 rows in 0 seconds using direct_path W-1 . . exported "TEST"."EMP" 6.531 KB 5 rows in 0 seconds using direct_path W-1 . . exported "COMP"."COUNTRIES" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "COMP"."DEPARTMENT" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "COMP"."EMPLOYEE" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "COMP"."JOBS" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "COMP"."JOB_HISTORY" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "COMP"."LOCATIONS" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "COMP"."REGIONS" 0 KB 0 rows in 0 seconds using direct_path W-1 Completed 1 DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA objects in 1 seconds W-1 Completed 67 DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA objects in 2 seconds W-1 Completed 18 DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA objects in 5 seconds W-1 Completed 9 DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA objects in 1 seconds W-1 Master table "TEST"."SYS_EXPORT_FULL_01" successfully loaded/unloaded ****************************************************************************** Dump file set for TEST.SYS_EXPORT_FULL_01 is: C:\BACKUP\FULL_DB.DMP Job "TEST"."SYS_EXPORT_FULL_01" successfully completed at Sat Mar 16 01:17:53 2024 elapsed 0 00:02:12 |
Thanks for reading this post ! Please comment if you like this post ! Click on FOLLOW to get future blog updates !
Thank you for visiting my blog ! Thanks for your comment !