advertisements
_____________________________________________________________________________________________________________________
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
_____________________________________________________________________________________________________________________
0 comments:
Post a Comment