5 Replies Latest reply on Apr 25, 2013 1:52 AM by 998140

    Change parallel works dynamically

    998140
      Hi,

      now I am doing export data pump for a data warehouse database,

      Export has been started and I use parallel=4, it is running now..

      1. Say if I want to increase parallel level to 16, how could I change it dynamically while the exp is running?

      ( now the exp rate is 5.1/hr far, do you think this rate is normal or not...SA want to change some NFS settings. I think increase the parallel works may not increase the speed of export, based on my past experience, somehow still feel a little slower than expected)

      Thank you very much.

      database is 10.2.0.3 in Linux