<<Back to Oracle DATAPUMP Main Page
Trace the Expdp and Impdp Performance Issue using LOGTIME and METRICS Parameter
of course you can track the time for each export/import operation and direct export/import job to write the timestamp in logfile using LOGTIME parameter. More on Expdp/Impdp LOGTIME Read HereBut if you like additional information about the job (eg. which process is doing what and taking how much time) you can use METRICS=Y parameter.
These parameters are useful to investigate datapump performance and estimate the time of similar export, import operation
METRICS
Default: NO
Syntax and DescriptionMETRICS=[YES | NO]
An Example
$ cat exp_full_pdb01.par
DIRECTORY=DUMP
DUMPFILE=EXP_PDB01_FULL%U.DMP
LOGFILE=EXP_PDB01_FULL.LOG
SCHEMAS=TEST
REUSE_DUMPFILES=Y
FLASHBACK_TIME=SYSTIMESTAMP
METRICS=Y
$ expdp system@PDB01 parfile=exp_full_pdb01.par
Export: Release 12.2.0.1.0 - Production on Fri Oct 26 13:14:59 2018
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Password:
Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_02": system/********@PDB01 parfile=exp_full_pdb01.par
W-1 Startup took 89 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 6 seconds
W-1 Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
W-1 Completed 1 TABLE_STATISTICS objects in 2 seconds
W-1 Processing object type SCHEMA_EXPORT/STATISTICS/MARKER
W-1 Completed 1 MARKER objects in 16 seconds
W-1 Processing object type SCHEMA_EXPORT/USER
W-1 Completed 1 USER objects in 4 seconds
W-1 Processing object type SCHEMA_EXPORT/ROLE_GRANT
W-1 Completed 2 ROLE_GRANT objects in 2 seconds
.................................................................................................................................................
.................................................................................................................................................
W-1 Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
W-1 Completed 1 INDEX objects in 2 seconds
W-1 Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
W-1 Completed 1 CONSTRAINT objects in 2 secondsW-1 . . exported "TEST"."PEOPLE" 6.796 KB 1 rows in 0 seconds using direct_pathW-1 Completed 1 SCHEMA_EXPORT/TABLE/TABLE_DATA objects in 0 seconds
W-1 Master table "SYSTEM"."SYS_EXPORT_SCHEMA_02" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_02 is:
/u01/dbatst2/stage/dump/EXP_PDB01_FULL01.dmp
Job "SYSTEM"."SYS_EXPORT_SCHEMA_02" successfully completed at Fri Oct 26 13:34:10 2018 elapsed 0 00:19:07
Comments
Post a Comment