Unanswered: dump database is taking ages to complete
I have situation where the dump database is taking longer to complete,
usually it take around 1.5 hours for this particular dump db to
finished but now its taking more than 4 hours. I have checked the logs
and all seems ok, I cant see any probable cause.
My question is, is there i way for me to check why the dump database
is take that long to complete or check the percentage of the dump.
Also would be good if you guys can point me out to where to check to
determine the cause of the problem.
Is there something else accessing the disks?
Are you using compression and something else hogging the CPU?
How long does it take to copy a large 1G file using the same disks?
If external disk unit, check that the write cache is still enabled.