Search the Community
Showing results for tags 'library cache load lock'.
Found 1 result
ayush posted a topic in Oracle ForumHi Donald, i am trying to build multiple indexes in parallel session i have table t1 which has partition p1 and sub partitions p1s1,p1s2,p1s3,p1s4......p1s500 from 15 parallel session i am picking 15 indexes and am trying to rebuild it. so my 15 session will be like: sess1: alter index i1 rebuild subpartition i1_p1s1 rebuild sess2: alter index i1 rebuild subpartition i1_p1s2 rebuild sess3: alter index i1 rebuild subpartition i1_p1s3 rebuild sess4: alter index i1 rebuild subpartition i1_p1s4 rebuild sess5: alter index i1 rebuild subpartition i1_p1s5 rebuild . . . . sess15: alter index i1 rebuild subpartition i1_p1s15 rebuild Now the problem i face is, these 14 sessions are waiting with library cache lock till session 1 completes it library cache load is it a normal behavior? I was under impression that subpartitions are different objects so one subpartition should not block the others work. machine details: num of instances: 4 num cpu : 80 num cpu core : 80 Oracle version: 11Gr2(22.214.171.124.0) 4 node RACS SGA: 300GB Shared pool: 30GB