• I did check in activity monitor for locks by process.

    I found one of the job1 which inserts the data into table'A' is holding a

    IX lock on the table.

    this job1 is causing all the jobs from job2 to job 10 to wait.

    but job1 has grant status.

    So, Do I kill this job1 ?

    but still job2 to job10 are going to perform the same insertions on the tableA.

    So, Is that problem due to job or due to table A?