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