This discussion is archived
1 Reply Latest reply: Nov 12, 2012 11:06 AM by jgarry RSS

Parallel creation of partitionned index and tablespace Temp size

N.Durand Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points