Datapump added a much
needed new parameter LOGTIME in Oracle 12C
LOGTIME keeps track of
timing datapump is consuming in each step and display the timestamp in output.
logtime takes 4 values
: NONE | STATUS | LOGFILE | ALL
This parameter is valid
for both expdp as well as impdp.
LOGTIME=STATUS (timestamp
is displayed on console output but not in datapump logfile.
[oracle@testing dpdump]$ expdp system schemas=AJ
directory=data_pump_dir dumpfile=expdp_aj.dmp logfile=expdp_aj.log
logtime=status
Export: Release 12.1.0.2.0 - Production on Wed Nov 2
01:16:34 2016
Copyright (c) 1982, 2014, Oracle and/or its
affiliates. All rights reserved.
Password:
Connected to: Oracle Database 12c Enterprise Edition
Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and
Real Application Testing options
Export logfile
(LOGTIME=STATUS)
[oracle@testing dpdump]$ cat expdp_aj.log
;;;
Export: Release 12.1.0.2.0 - Production on Wed Nov 2
01:16:34 2016
Copyright (c) 1982, 2014, Oracle and/or its
affiliates. All rights reserved.
;;;
Connected to: Oracle Database 12c Enterprise Edition
Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and
Real Application Testing options
Starting
"SYSTEM"."SYS_EXPORT_SCHEMA_01": system/******** schemas=AJ directory=data_pump_dir
dumpfile=expdp_aj.dmp logfile=expdp_aj.log logtime=status
Estimate in progress using BLOCKS method...
Processing object type
SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 640 KB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type
SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type
SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type
SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
. . exported "AJ"."TABLE1" 6.773 KB 1 rows
. . exported "AJ"."TABLE10" 6.773 KB 1 rows
. . exported "AJ"."TABLE2" 6.773 KB 1 rows
. . exported "AJ"."TABLE3" 6.773 KB 1 rows
. . exported "AJ"."TABLE4" 6.773 KB 1 rows
. . exported "AJ"."TABLE5" 6.773 KB 1 rows
. . exported "AJ"."TABLE6" 6.773 KB 1 rows
. . exported "AJ"."TABLE7" 6.773 KB 1 rows
. . exported "AJ"."TABLE8" 6.773 KB 1 rows
. . exported "AJ"."TABLE9" 6.773 KB 1 rows
Master table
"SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully
loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:
/u02/app/oracle/admin/LONDON/dpdump/expdp_aj.dmp
Job
"SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at
Wed Nov 2 01:18:02 2016 elapsed 0 00:01:14
LOGTIME=LOGFILE (timestamp
is displayed in datapump logfile but not on console output.
[oracle@testing dpdump]$ expdp system schemas=AJ
directory=data_pump_dir dumpfile=expdp_aj.dmp logfile=expdp_aj.log
logtime=LOGFILE
Export: Release 12.1.0.2.0 - Production on Wed Nov 2
01:20:37 2016
Copyright (c) 1982, 2014, Oracle and/or its
affiliates. All rights reserved.
Password:
Connected to: Oracle Database 12c Enterprise Edition
Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and
Real Application Testing options
Starting
"SYSTEM"."SYS_EXPORT_SCHEMA_01": system/******** schemas=AJ
directory=data_pump_dir dumpfile=expdp_aj.dmp logfile=expdp_aj.log
logtime=LOGFILE
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 640 KB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type
SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type
SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type
SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
. . exported "AJ"."TABLE1" 6.773 KB 1 rows
. . exported "AJ"."TABLE10" 6.773 KB 1 rows
. . exported "AJ"."TABLE2" 6.773 KB 1 rows
. . exported "AJ"."TABLE3" 6.773 KB 1 rows
. . exported "AJ"."TABLE4" 6.773 KB 1 rows
. . exported "AJ"."TABLE5" 6.773 KB 1 rows
. . exported "AJ"."TABLE6" 6.773 KB 1 rows
. . exported "AJ"."TABLE7" 6.773 KB 1 rows
. . exported "AJ"."TABLE8" 6.773 KB 1 rows
. . exported "AJ"."TABLE9" 6.773 KB 1 rows
Master table
"SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully
loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:
/u02/app/oracle/admin/LONDON/dpdump/expdp_aj.dmp
Job
"SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at
Wed Nov 2 01:21:01 2016 elapsed 0 00:00:19
Export logfile
(LOGTIME=LOGFILE)
[oracle@testing dpdump]$ cat expdp_aj.log
;;;
Export: Release 12.1.0.2.0 - Production on Wed Nov 2
01:20:37 2016
Copyright (c) 1982, 2014, Oracle and/or its
affiliates. All rights reserved.
;;;
Connected to: Oracle Database 12c Enterprise Edition
Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and
Real Application Testing options
LOGTIME=ALL (timestamp is
displayed both in datapump logfile as well as console output)
[oracle@testing dpdump]$ expdp system schemas=AJ
directory=data_pump_dir dumpfile=expdp_aj.dmp logfile=expdp_aj.log logtime=ALL
Export: Release 12.1.0.2.0 - Production on Wed Nov 2
01:22:13 2016
Copyright (c) 1982, 2014, Oracle and/or its
affiliates. All rights reserved.
Password:
Connected to: Oracle Database 12c Enterprise Edition
Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and
Real Application Testing options
Export logfile
(LOGTIME=ALL)
[oracle@testing dpdump]$ cat expdp_aj.log
;;;
Export: Release 12.1.0.2.0 - Production on Wed Nov 2
01:22:13 2016
Copyright (c) 1982, 2014, Oracle and/or its
affiliates. All rights reserved.
;;;
Connected to: Oracle Database 12c Enterprise Edition
Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and
Real Application Testing options
[oracle@testing dpdump]$
This timestamp
information is very useful. They tell how much time each object is taking to
export.
This help in planning
other activities on production database.
To get the same
information prior to 12c, we can set trace on datapump process using TRACE
parameter or process tracing.
No comments:
Post a Comment
Leave a Reply...