Sometimes the lock handler table overflows, and the session or job is canceled. You can solve it easily. Just change the profile parameter enque/table_size. This parameter has a default value of around 4096(KB). Thus 5000 entries can be entered in the tables. If you change this parameter to 32000(KB), approximately 40000 entries can be entered in the table.