1 2 Previous Next 17 Replies Latest reply: Oct 18, 2012 12:45 AM by CBessios Go to original post RSS
      • 15. Re: 11.2.0.2 AW size grows steadily with every cube build
        CBessios
        Hi David

        I just completed the 10 loads with atomic_refresh=false. Resulting aw size as follows:

        Schema Only     180     
        Load Dimension Data Only     271
        Cube Build 1     586     +135
        Cube Build 2     715     +129
        Cube Build 3     851     +136
        Cube Build 4     995     +144
        Cube Build 5     1099     +104
        Cube Build 6     1099     +0
        Cube Build 7     1108     +9
        Cube Build 8     1117     +9
        Cube Build 9     1117     +0
        Cube Build 10     1118     +1
        Cube Build 11     1126     +8

        It seems that after build 5, aw size stabilize. I don't know if this is expected behaviour but I think that your remark is correct (for the atomic_refresh). Of course the atomic_refresh is a necessary functionality.

        Thank you very much.

        Chris
        • 16. Re: 11.2.0.2 AW size grows steadily with every cube build
          DavidGreenfield
          Hi Chris,

          This is the exactly the kind of AW growth that I would expect. I have logged a bug on this issue. At this stage it appears to be limited to the 11.2.0.2 OLAP patches.

          Bug 14768947 - ATOMIC CUBE BUILDS LEAD TO UNLIMITED AW GROWTH

          David
          • 17. Re: 11.2.0.2 AW size grows steadily with every cube build
            CBessios
            Hi David.

            Thank you for all your support! I switch to atomic_refresh=false for all my builds until the patch is available.

            Chris
            1 2 Previous Next