4 Replies Latest reply: Nov 14, 2012 6:52 AM by Osama_Mustafa RSS

    expdp in 10g hangs

    846231
      Hi all,

      I am running an expdp in 10g and it is very long time to process and hanging. Same command in 11g is very fast.

      C:\Documents and Settings\admin>expdp cisprod/cisprod
      
      Export: Release 10.2.0.3.0 - Production on Wednesday, 14 November, 2012 19:51:04
      
      
      Copyright (c) 2003, 2005, Oracle.  All rights reserved.
      
      Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Produc
      tion
      With the Partitioning, OLAP and Data Mining options
      Starting "CISPROD"."SYS_EXPORT_SCHEMA_01":  cisprod/********
      Estimate in progress using BLOCKS method...
      Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
      Total estimation using BLOCKS method: 3.342 GB
      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/SYNONYM/SYNONYM
      Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC
      Processing object type SCHEMA_EXPORT/DB_LINK
      Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
      Processing object type SCHEMA_EXPORT/TABLE/TABLE
      Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
      Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
      Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
      Processing object type SCHEMA_EXPORT/TABLE/COMMENT
      Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
      Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
      Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
      Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_
      PACKAGE_SPEC
      Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
      Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
      Processing object type SCHEMA_EXPORT/VIEW/VIEW
      Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
      Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
      Processing object type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_AND_BITMAP/INDEX
      Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_AND_BITMA
      P/INDEX_STATISTICS
      Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
      It is stuck on the above line.

      What parameter do I increase to speedup 10g expdp? I remember I got error on stream_pool_size, Then I set it to 100M. Is it enough or not?
      What should be the recommended size of streams in 10g?


      Thanks a lot,
      Kinz