1 2 3 Previous Next 31 Replies Latest reply: Dec 14, 2012 9:14 AM by Penky Go to original post RSS
      • 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).

        Randolf
        • 31. Re: Please help with parallel query
          Penky
          Randolf,

          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 11.2.0.2 Patch 11 or 11.2.0.3 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