Here we will be discussing metrics parameter used in expdp or
impdp utility, here is the definition of metrics as per oracle, it provides
additional information about the export job in the export log file, we will see
with the help of an example
METRICS
Report additional job
information to the export log file [NO].
I performed
export with 2 methods
1. Without
metrics parameter
2. Without
metrics parameter
and here is
the result of the same
without
Connected to: Oracle
Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Starting
"TECHNO_USER"."SYS_EXPORT_SCHEMA_01":
userid=techno_user/********@technopdb directory=export_dir
dumpfile=expdp_techno_users1.dmp logfile=expdp_techno_users.log
Processing object type
SCHEMA_EXPORT/TABLE/TABLE_DATA
Processing object type
SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type
SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type
SCHEMA_EXPORT/STATISTICS/MARKER
Processing object type
SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type
SCHEMA_EXPORT/TABLE/TABLE
Processing object type
SCHEMA_EXPORT/TABLE/COMMENT
Processing object type
SCHEMA_EXPORT/TABLE/AUDIT_OBJ
Processing object type
SCHEMA_EXPORT/TABLE/INDEX/INDEX
. . exported
"TECHNO_USER"."DEPTS"
393.4 KB 12002 rows
. . exported
"TECHNO_USER"."DUMMY"
5.085 KB
3 rows
. . exported
"TECHNO_USER"."DUMMY1"
5.085 KB 2
rows
. . exported
"TECHNO_USER"."EMPLOYEES"
393.4 KB 12002 rows
. . exported
"TECHNO_USER"."PERSONS"
425.6 KB 13002 rows
Master table
"TECHNO_USER"."SYS_EXPORT_SCHEMA_01" successfully
loaded/unloaded
******************************************************************************
Dump file set for
TECHNO_USER.SYS_EXPORT_SCHEMA_01 is:
C:\DOWNLOADS\ARCH\EXPDP_TECHNO_USERS1.DMP
Job
"TECHNO_USER"."SYS_EXPORT_SCHEMA_01" successfully completed
at Thu Jun 2 19:55:23 2022 elapsed 0 00:00:20
With
Connected to: Oracle
Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Starting
"TECHNO_USER"."SYS_EXPORT_SCHEMA_01": userid=techno_user/********@technopdb
directory=export_dir dumpfile=expdp_techno_users.dmp
logfile=expdp_techno_users.log metrics=yes
W-1 Startup took 0
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 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 5 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 13 seconds
W-1 Processing object
type SCHEMA_EXPORT/TABLE/COMMENT
W-1 Processing object
type SCHEMA_EXPORT/TABLE/AUDIT_OBJ
W-1
Completed 2 AUDIT_OBJ objects in 0 seconds
W-1 Processing object
type SCHEMA_EXPORT/TABLE/INDEX/INDEX
W-1 . . exported
"TECHNO_USER"."DEPTS"
393.4 KB 12002 rows
in 0 seconds using direct_path
W-1 . . exported
"TECHNO_USER"."DUMMY"
5.085 KB
3 rows in 0 seconds using direct_path
W-1 . . exported
"TECHNO_USER"."DUMMY1"
5.085 KB 2
rows in 0 seconds using direct_path
W-1 . . exported
"TECHNO_USER"."EMPLOYEES"
393.4 KB 12002 rows in 0 seconds
using direct_path
W-1 . . exported
"TECHNO_USER"."PERSONS"
425.6 KB 13002 rows in 0
seconds using direct_path
W-1
Completed 5 SCHEMA_EXPORT/TABLE/TABLE_DATA objects in 0 seconds
W-1 Master table
"TECHNO_USER"."SYS_EXPORT_SCHEMA_01" successfully
loaded/unloaded
******************************************************************************
Dump file set for
TECHNO_USER.SYS_EXPORT_SCHEMA_01 is:
C:\DOWNLOADS\ARCH\EXPDP_TECHNO_USERS.DMP
Job
"TECHNO_USER"."SYS_EXPORT_SCHEMA_01" successfully completed
at Thu Jun 2 19:53:15 2022 elapsed 0 00:00:33
Here is the conclusion
Export without metrics parameter gives
simple log file with much information about objects
Export with metrics parameter give details
about a number of objects, time taken by objects to get exported, details about
workers.
0 comments:
Post a Comment