Hi Team,
I need your help for understanding below scenario.
We have below tables database
1. customer
2.order
customer table is parent table and in that we have customerid as primary key and child table has customerid as forignkey to parent table.
In my understanding - Ideally if we update records in child table it should not lock parent table and we have index on both tables (on primary key and foreignkey).
currently i am facing opposite situation - we are trying to update records in child table and it is locking the parent table(parent table is oltp table), due to that reason we are seeing blocking sessions in our data base.
Please suggest how to overcome this situation.
Thanks in Advance