Recently we have migrated our oracle database from 10gR2 to 11gR2. Currently we are using 10gR2 oracle application server and forms and reports for front end.Check for the owner of the session who is blocking.. Is it any background process? or is this by normal users.
After migrating we are experiencing the locking issues. ( Some sessions are blocking other sessions). But in 10g we didnt experienced it. There is no changes in the objects after migration.
Please provide us what are the possiblities or how to solve this issue.
"And the rule in Oracle Database 11g Release 1 and later is that you will want an index on the foreign key of the child table if you do any of the following: Update the parent table primary key Delete from the parent table Use a merge that either updates the parent table primary key or deletes from the parent table "
Suresh Kumar VS wrote:When the lock occurs, you can check DBA_WAITERS, then identify what the waiting session is doing (WAITING_SESSION is its SID), and check which object is concerned (LOCK_ID1 is the OBJECT_ID for TM lock), and check what the holding session (HOLDING_SESSION is his SID) has done on that object (or on an object that is linked with referential integrity with it).
The table which seems causing the lock has primary key but no other table refering it.