You need to seriously look at your application code and review it with the developers. For most part, Oracle default locking mechanisms are enough and you do not need so many locks for update nowait.