Datapump import job hang
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Datapump import job hang

  1. #1
    Join Date
    Jul 2005
    Posts
    87

    Datapump import job hang

    Hi,
    I am doing an import with datapump teh job seem to like hang not going anywhere since 10hrs i know for the fact that something is wrong somewhere,
    staus of job from dba_datapump_jobs says executing,its trying to create materialized view and it stuck there almost 10hrs now,alert shows no errors too .Here is the output from

    Import> status

    Job: SYS_IMPORT_FULL_06
    Operation: IMPORT
    Mode: FULL
    State: EXECUTING
    Bytes Processed: 360,286,816
    Current Parallelism: 1
    Job Error Count: 0
    Dump File: /u01/app/oracle/reorg/GPOGLD/impdp_dir/GPOTGL120070627.DMP

    Worker 1 Status:
    State: EXECUTING
    Object Schema: GPC
    Object Name: VENDOR
    Object Type: DATABASE_EXPORT/SCHEMA/MATERIALIZED_VIEW
    Worker Parallelism: 1

    output from dba_resumable:
    SQL> select * from dba_resumable;



    USER_ID SESSION_ID INSTANCE_ID COORD_INSTANCE_ID COORD_SESSION_ID STATUS

    ---------- ---------- ----------- ----------------- ---------------- ---------

    TIMEOUT START_TIME SUSPEND_TIME RESUME_TIME

    ---------- -------------------- -------------------- --------------------

    NAME

    --------------------------------------------------------------------------------

    SQL_TEXT

    --------------------------------------------------------------------------------

    ERROR_NUMBER

    ------------

    ERROR_PARAMETER1

    --------------------------------------------------------------------------------

    ERROR_PARAMETER2

    --------------------------------------------------------------------------------

    ERROR_PARAMETER3

    --------------------------------------------------------------------------------

    ERROR_PARAMETER4

    --------------------------------------------------------------------------------

    ERROR_PARAMETER5

    --------------------------------------------------------------------------------

    ERROR_MSG

    --------------------------------------------------------------------------------

    0 29 1 NORMAL



    USER_ID SESSION_ID INSTANCE_ID COORD_INSTANCE_ID COORD_SESSION_ID STATUS

    ---------- ---------- ----------- ----------------- ---------------- ---------

    TIMEOUT START_TIME SUSPEND_TIME RESUME_TIME

    ---------- -------------------- -------------------- --------------------

    NAME

    --------------------------------------------------------------------------------

    SQL_TEXT

    --------------------------------------------------------------------------------

    ERROR_NUMBER

    ------------

    ERROR_PARAMETER1

    --------------------------------------------------------------------------------

    ERROR_PARAMETER2

    --------------------------------------------------------------------------------

    ERROR_PARAMETER3

    --------------------------------------------------------------------------------

    ERROR_PARAMETER4

    --------------------------------------------------------------------------------

    ERROR_PARAMETER5

    --------------------------------------------------------------------------------

    ERROR_MSG

    --------------------------------------------------------------------------------

    7200



    Please let me know what is wrong and where.

    Thanks

  2. #2
    Join Date
    Jun 2005
    Location
    Florida
    Posts
    41
    Identify the job using:
    select job_name,state from dba_datapump_jobs;

    Check in alert log if there is any alerts on tablespace full etc...
    Milind
    -----------------------------
    www.milinds.com
    My Private World on the Web !

  3. #3
    Join Date
    Jun 2005
    Location
    Florida
    Posts
    41
    Do you have a resumable_timeout set to= 7200 secs? just guessing
    Milind
    -----------------------------
    www.milinds.com
    My Private World on the Web !

  4. #4
    Join Date
    Jul 2005
    Posts
    87
    Alert log have no alerts about tablespace being full,by default i am assuming datapump has resumable_timeout set to= 7200

  5. #5
    Join Date
    Jun 2005
    Location
    Florida
    Posts
    41
    Did you try to stop_job and then start_job to see if it kicks off ? You can do it on import> prompt
    Milind
    -----------------------------
    www.milinds.com
    My Private World on the Web !

  6. #6
    Join Date
    Jan 2001
    Posts
    3,131
    Datapump has issues with consuming memory on the OS side, I would look into that.
    I remember when this place was cool.

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    look at wait events

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width