Oracle 12c Data Pump EXPDP IMPDP Logtime Option Parameter

One new parameter introduced in Oracle 12c data pump which is called logtime. This is a command-line parameter which will display the messages or status in log with time stamped format. This parameter helps the DBA to identify the time taken for each granule of export job. There are 4 possible options available for logtime parameter.

            a.   NONE – By default value and it will not show any timestamp
            b.   STATUS – Will display the timestamp for status messages
            c.   LOGTIME – Will display timestamp for log file messages
            d.   ALL – will display timestamp for both status   and logfile messages.
Sample output or logfile would in this below format.
24-JUL-13 16:32:35.300: Starting "SYS"."QUERY_EXPORT":  /******** AS SYSDBA parfile=exp.par
24-JUL-13 16:32:35.412: Estimate in progress using BLOCKS method...
24-JUL-13 16:32:42.715: Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
24-JUL-13 16:33:15.654: Total estimation using BLOCKS method: 109.2 GB
24-JUL-13 16:35:25.113: Processing object type TABLE_EXPORT/TABLE/TABLE
24-JUL-13 16:35:45.230: Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
24-JUL-13 16:36:15.370: Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
24-JUL-13 16:36:39.349: Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
24-JUL-13 16:38:27.765: Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
24-JUL-13 16:38:45.984: Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
24-JUL-13 16:41:35.178: Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google