5 Replies Latest reply on Jun 12, 2014 6:33 AM by 1052085

    ORA-00054: resource busy error when updating different subpartitions in parallel

    1052085

      Hi,

      I've a table which has 40 subpartitions. I've created 4 different procedures, each procedures updating 10 different subpartitions on a single column.

      The column has a bitmap index which i'm putting in UNUSABLE state before update. And as soon as i'm done with the update on a subpartition, i'm rebuilding the bitmap index for that subpartition.

       

      But i'm facing the below error while running the 4 different procedure in parallel.

      ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

       

      I'm not able to debug the the issue. When i'm updating different subpartition and rebuilding different subpartition indexes then why resource busy?

       

      Oracle Version: 11.2.0.2.0

       

      Thanks.