expdp hangs for large tables - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: expdp hangs for large tables

  1. #11
    Join Date
    Dec 2002
    Posts
    89
    I did gather the stats and also check the sessions are active, it creates 3 active session and 2 of the session have the above wait and 3rd session have db_sequential_read with 0s wait.

  2. #12
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Monitor the size of the dump file, is the dump file getting larger as time goes by?

    Yes: your process is working and writting on the file.
    No: your process is crispy fried.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #13
    Join Date
    Dec 2002
    Posts
    89
    No. It stays as 4kb

  4. #14
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Do you have free space in the affected filesystem or is it full?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  5. #15
    Join Date
    Dec 2002
    Posts
    89
    yes, I do have enough free space at dumpfile location. Also I am only doing estimate disk space. When I drop the unique key the estimation part does work, but estimation hangs as soon as I add unique key constraint.

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