6 Replies Latest reply: Oct 1, 2013 8:30 AM by DK2010 RSS

    Expdp and impdp

    974882

      Hi ,

       

      I am doing export of full database with parallel=8 syntax but while checking through status its showing only one. ....Pls suggest.

      Also one more point, if my putty session get closed, do my export job get terminiated . I suppose not ..Pls suggest.

       

      Export> status

      Job: EXPORT_EBP
        Operation: EXPORT
        Mode: FULL
        State: EXECUTING
        Bytes Processed: 0
        Current Parallelism: 8
        Job Error Count: 0
        Dump File: /dbexport/export/export_FULL_01.dmp
          bytes written: 4,096
        Dump File: /dbexport/export/export_FULL_%u.dmp

      Worker 1 Status:
        Process Name: DW00
        State: EXECUTING
        Object Schema: SAPDAT
        Object Name: /BI0/F0PA_C01
        Object Type: DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
        Completed Objects: 24,000
        Worker Parallelism: 1

        • 1. Re: Expdp and impdp
          DK2010

          Hi,

           

          >>I am doing export of full database with parallel=8 syntax but while checking through status its showing only one. ....Pls suggest.

          Do you have lob object on tables, how many dump file generated on your directory ?

          >>Also one more point, if my putty session get closed, do my export job get terminiated . I suppose not ..Pls suggest.

          No, it will run in background

          • 2. Re: Expdp and impdp
            974882

            And Job status of export job:

             

            Estimate in progress using BLOCKS method...

            Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA

            • 3. Re: Expdp and impdp
              974882

              Hi ,

               

              Only one dumpfile is created...Yes we have LOB segments and LOB indexes

               

              This is my syntax :

               

              expdp system/*****@***  directory=export parallel=8 COMPRESSION=ALL dumpfile=export_FULL_%U.dmp logfile=export_FULL.log JOB_NAME=export FULL=Y

              • 4. Re: Expdp and impdp
                sybrand_b

                1 use the scheduler of database control (or the scheduler in the database) and putty doesn't bother you anymore

                2 or use 'nohup expdp  .... &' and putty doesn't bother you anymore

                3 or use (obsolete) cron

                 

                Oracle is using an algorithm in expdp to determine the number of parallel jobs. Your situation may not qualify for more than 1 job.

                 

                ----------

                Sybrand Bakker

                Senior Oracle DBA

                • 5. Re: Expdp and impdp
                  974882

                  Hi Sybrand,

                   

                  Thanks for such a usefull replay ...

                   

                  Yes, i am agree as my export job is right now seems doing estimation of blocks. I also read that gathering statistics, data are always done by only ONE worker....

                   

                  This is the current status:

                  ===================================================================

                  Estimate in progress using BLOCKS method...

                  Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA

                  ===================================================================

                   

                  Thanks,

                  • 6. Re: Expdp and impdp
                    DK2010

                    Hi,

                     

                    Found good doc on support site, you can also check :Parallel Capabilities of Oracle Data Pump (Doc ID 365459.1)

                     

                    HTH