Jump to content

Search the Community

Showing results for tags 'library cache lock'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type



Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


AIM


MSN


Website URL


ICQ


Yahoo


Jabber


Skype


Location


Interests

Found 1 result

  1. Hi 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(11.2.0.4.0) 4 node RACS SGA: 300GB Shared pool: 30GB
×