|
-
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.
-
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.
-
-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote