I recently upgraded my database from 11.5 to 12.5.1 to use the new data row locking features. I implemented locking on all my tables that need it using alter table but I was wondering if there anything else I should do to ensure proper performance(I saw somewhere, something about row locking in a server level and maximum row size) because there doesn't seem to be any difference from before(my users seem to work even slower than before with the new locking scheme).
Thanks, I will try it out. I was more concerned about the fact that the users block each other more often now with data row locking than before without. Is this because I might have locked the wrong tables or is there any more configuration on the server side to make it work properly for all tables.