This discussion is archived
4 Replies Latest reply: Nov 28, 2012 6:13 AM by Richard Harrison . RSS

Help to improve expdp performance and compression

976092 Newbie
Currently Being Moderated
Hi,

We have a oracle standard Edition which do not support parallel , compression features of expdp.

The expdp dmp file is around 90GB and it takes 45 minutes to create in production server . Then the scripts compresses the file with gzip utility and compression takes 80 minutes.

To copy the compressed file from prod to staging server it takes another 47 minutes .

We have automated the process but it takes long time for expdp + compression + copy ( Around 3 hrs ) . On staging server it does take more than 4 hours to create the staging db.

Is there anyway I can improve the performance of these 3 operations .

Can I do compression while file is exporting ? I tried using pipes in unix and it doesn't work for expdp.

We don't want to use network link .

Will expdp commands writes the file sequentially ? If so , can I start gzipping parallely when files are exported .

Also tried compressing with gzip -1 option , but it has increased the file size by 30% , and eventually increased the copy time to staging server .

Please help

Thanks,
Bharani J

Edited by: 973089 on Nov 27, 2012 9:40 AM

Edited by: 973089 on Nov 27, 2012 9:41 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points