1 Reply Latest reply: Nov 12, 2012 1:06 PM by jgarry RSS

    Parallel creation of partitionned index and tablespace Temp size

    N. Durand
      Hi,

      I'am not able to find the information if when building in parallel a locally partitionned index, Oracle will iterate on all the partition and then use temp tbs for one partitionned or it will compute for all the partitionned simultaneously ?

      Thanks for your help
        • 1. Re: Parallel creation of partitionned index and tablespace Temp size
          jgarry
          If I understand your question correctly, the temp tablespace is used for sorting, but there are temp segments created in the tablespaces where the indices will actually belong. See the demo on how to work it out for yourself: http://hemantoracledba.blogspot.com/2008/05/temporary-segments-in-dataindex.html

          Also find Randolf's blog for some other interesting factoids: http://oracle-randolf.blogspot.com/2011/02/parallel-dml-conventional-non-direct.html