I think locking is not possible for any case because each user just say

user1 has 1 to 100k records to insert and same for update

user 2 has 101k to 200k records...same user9 has 801k to 900k records

what i want to know as per current scenario it is advisable to create a table partition