Monday, September 30, 2013

Data pump Timing details

One of my export  job running more than 8 hours but did not seen any progress on log file and dumpfile .  after  googling i found below help full  undocumented parameter METRICS .
With the undocumented parameter METRICS additional information can be obtained about the number of objects that were processed and the time it took for processing them. Objects in this context are for example the exported system GRANT privileges, the imported tablespace quota GRANT statements, the exported CREATE TABLE statements. Note that the METRICS parameter does not create any additional trace files. Instead, the extra details are logged in the logfile of the Export Data Pump or Import Data Pump job.
Example output:

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
FLASHBACK automatically enabled to preserve database integrity.
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_04":  system/******** directory=test_dir dumpfile=ac_20130830.dmp logfile=exp_0830.log schemas=xxx EXCLUDE=GRANT METRICS=y
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 6.370 GB
Processing object type SCHEMA_EXPORT/USER
     Completed 1 USER objects in 0 seconds
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
     Completed 8 SYSTEM_GRANT objects in 1 seconds
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
     Completed 1 DEFAULT_ROLE objects in 0 seconds
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
     Completed 2 TABLESPACE_QUOTA objects in 0 seconds
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
     Completed 1 PROCACT_SCHEMA objects in 3 seconds
Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC
     Completed 239 TYPE objects in 1 seconds
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
     Completed 354 SEQUENCE objects in 3 seconds
Processing object type SCHEMA_EXPORT/TABLE/TABLE
     Completed 457 TABLE objects in 8 seconds
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
     Completed 850 INDEX objects in 2 seconds
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
     Completed 2350 CONSTRAINT objects in 5 seconds
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
     Completed 851 INDEX_STATISTICS objects in 1 seconds
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
     Completed 2423 COMMENT objects in 4 seconds
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
     Completed 77 PACKAGE objects in 1 seconds
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
     Completed 51 PROCEDURE objects in 0 seconds
Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
     Completed 77 ALTER_PACKAGE_SPEC objects in 0 seconds


Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE

No comments:

Post a Comment