1 2 3 Previous Next 31 Replies Latest reply on Dec 14, 2012 3:14 PM by Penky Go to original post
      • 30. Re: Please help with parallel query
        Randolf Geist
        One other thought: I should have pointed out already that you don't need to mark your objects with PARALLEL if you use PARALLEL_DEGREE_POLICY = AUTO.

        You would only need to do that if you use the LIMITED setting for Auto-DOP (which says that it only applies to objects marked with DEFAULT PARALLEL degree).

        • 31. Re: Please help with parallel query

          thanks again for your valuable time, I really appreciate it.

          I'll go ahead and start experimenting with lower values of PMBPS by setting it manually as described in ID 1269321.1
          Initially I thought PMBPS has to do something with parallel ("Parallel MB/s" or something) but it seems like this is the "maximum megabytes per second of large I/O requests that can be sustained by a single process" (from ORACLE Docs).

          I think the calculation of this is simply wrong. The value of ~1GB/s can be reached (in our case) with maybe 16 or 32 processes accessing the file system at the same time, but in no way by a single process. Maybe ORACLE mixed up something in their I/O calibration package. I also noticed that the bug "Bug 10180307 - Dbrm dbms_resouce_manager.calibrate_io reports very high values for max_pmbps [ID 10180307.8]" is already fixed in Patch 11 or onwards. Installing one of those might be an option once I can find time for the next maintenance window of this database. Untfortunately I can not shut it down at the moment and try.

          Thank you as well for the explanations on how to set the degree of parallelism manually. I marked this question as "answered" since I feel we discovered the root cause of ORACLE not using parallel query in my case.

          THANKS ;-) !!!
          1 2 3 Previous Next