Hi guys,
I have a client has an application with a lot of DMLs. Insert, update and deleted are operations occurred every day and on different hours. Because of that we have a lot of LOCK tables and lock on DML on tables.
In order to get less kind of errors we did some actions:
- created some foreign keys in order to reinforce access to tables.
- statistics every day.
- Modify the INITRANS PARAMETER on tables affected and its indexes also.
- Re-scheduled some refresh operations on tables.
But those actions don't fix our lock problems at all.
Do you have more actions in order to improve in our database?
Facts:
Oracle Enterprise Ed 11.1
Please, your kindly help.
Thank you