HiveBrain v1.2.0
Get Started
← Back to all entries
snippetMinor

How can a datapump export have its resource usage limited on linux?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
canresourceitsusageexportdatapumphowlinuxhavelimited

Problem

Doing an export of a number of users causes high CPU and I/O usage. I can mitigate the effects of the CPU usage using Resource Manager and setting the export session to a low priority group, but how can I limit the disk I/O? I am not running the operation in parallel and have already read Oracle's Datapump Performance documentation. Is there anything else I can do?

Solution

Ionice can limit disk usage

Take a look at the ionice utility for linux, as it seems to suit your needs quite well.

Context

StackExchange Database Administrators Q#361, answer score: 6

Revisions (0)

No revisions yet.