Re: locks onDB

Posted by ErmanArslansOracleBlog on May 25, 2023; 7:40am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/locks-onDB-tp11912p11918.html

Is it insert operation?
What is the db wait of the session?

If it is an insert, constraints (unique index/unique constraint / primary key) may be causing this. Consider 2 or more inserts almost at the same time to the same table, session 1 inserted data, but didn't commit and there is a constraint, so the second session will wait even though they are all insert operations.. Because Oracle doesn't now , the first session will commit or rollback and that's why to ensure the constraint is not violated, it will make second session wait, till the first one issue a commit or rollback.. So keep that in mind and analyze your environment.