How to use the METRICS Parameter by using expdp in Oracle database 19C
Posted by Mir Sayeed Hassan on December 3rd, 2024
How to use the METRICS Parameter by using expdp in Oracle database 19C
Brief: – This will give the information about the number of objects associated along with the elapsed time.
– Default METRICS=N, To apply this Parameter use METRICS=Y
Check the database version
SYS> select name, status, open_mode, version from V$database, v$instance; NAME STATUS OPEN_MODE VERSION ------------------------------------------------ ORA19CDB OPEN READ WRITE 19.0.0.0.0
[oracle@ora19cdb dump_bkp1]$ expdp directory=dump_bkp1 dumpfile=hassan_sch.dmp logfile=hassan_sch.log schemas=hassan METRICS=Y Export: Release 19.0.0.0.0 - Production on Tue Dec 03 09:14:27 2024 Version 19.18.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. Username: / as sysdba Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Starting "SYS"."SYS_EXPORT_SCHEMA_01": /******** AS SYSDBA directory=dump_bkp1 dumpfile=hassan_sch.dmp logfile=hassan_sch.log schemas=hassan METRICS=Y W-1 Startup took 1 seconds W-1 Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA W-1 Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS W-1 Completed 2 INDEX_STATISTICS objects in 0 seconds W-1 Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS W-1 Completed 5 TABLE_STATISTICS objects in 0 seconds W-1 Processing object type SCHEMA_EXPORT/STATISTICS/MARKER W-1 Completed 1 MARKER objects in 1 seconds W-1 Processing object type SCHEMA_EXPORT/USER W-1 Completed 1 USER objects in 0 seconds W-1 Processing object type SCHEMA_EXPORT/SYSTEM_GRANT W-1 Completed 1 SYSTEM_GRANT objects in 0 seconds W-1 Processing object type SCHEMA_EXPORT/ROLE_GRANT W-1 Completed 3 ROLE_GRANT objects in 0 seconds W-1 Processing object type SCHEMA_EXPORT/DEFAULT_ROLE W-1 Completed 1 DEFAULT_ROLE objects in 0 seconds W-1 Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA W-1 Completed 1 PROCACT_SCHEMA objects in 0 seconds W-1 Processing object type SCHEMA_EXPORT/TABLE/TABLE W-1 Completed 5 TABLE objects in 1 seconds W-1 Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE W-1 Completed 1 PROCEDURE objects in 0 seconds W-1 Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE W-1 Completed 1 ALTER_PROCEDURE objects in 0 seconds W-1 Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX W-1 Completed 1 INDEX objects in 3 seconds W-1 . . exported "HASSAN"."BOWIE" 688.8 KB 10000 rows in 0 seconds using direct_path W-1 . . exported "HASSAN"."ADD_PICTURE" 0 KB 0 rows in 0 seconds using direct_path W-1 . . exported "HASSAN"."T1" 5.632 KB 9 rows in 0 seconds using direct_path W-1 . . exported "HASSAN"."TEST1" 5.125 KB 4 rows in 0 seconds using direct_path W-1 . . exported "HASSAN"."TEST2" 5.109 KB 2 rows in 1 seconds using direct_path W-1 Completed 5 SCHEMA_EXPORT/TABLE/TABLE_DATA objects in 1 seconds W-1 Master table "SYS"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded ****************************************************************************** Dump file set for SYS.SYS_EXPORT_SCHEMA_01 is: /u02/backup/dump_bkp1/hassan_sch.dmp Job "SYS"."SYS_EXPORT_SCHEMA_01" successfully completed at Tue Dec 03 09:14:57 2024 elapsed 0 00:00:26