This content has been marked as final. Show 5 replies
Given the resources that Data Pump uses I believe this is not a good practice and should be avoided if possible.
Run Data Pump on an idle system and then check "top" and you will get an idea how much cpu and memory it is using.
"Data Pump technology fully uses all available resources to maximize throughput and minimize elapsed job time"
Needs must. If you don't run expdp parallel then it doesn't use that much. If it was really killing the system then look into setting up a Resource plan that knocks that user down but this is a big step.
I woud better look into using Rman
system incrementals, and block change tracking, to minimize your RMAN time.
If your shop needs to do both simultaneously then go for it.
PS : One of my shops has maybe 20-30 rmans and pumps all kicking off some simultaneous, some not, from 0000 to 0130. No complaints from users and no problems either. Go for it.
Edited by: Chris Slattery on Nov 25, 2012 11:19 PM