This content has been marked as final. Show 4 replies
do any of these tables contain Foreign Key?
Any bitmap indexes on the tables?
Your sessions are holding mode 3 TM locks, requesting mode 5 TM locks, on object id 1920980.
Look up that object id from user/dba_objects and double check the indexes involved in foreign keys, particularly on delete cascase.
Futher information on the statements involved and the relevant relationships would be useful, as well as confirmation of the index now being local or global.
Thank you very much to everyone who responded so promptly to this thread. I appreciate your willingness to provide great information.
It appeared that the deadlocks were occurring as a result of the partitioning, but upon further investigation, there were many constraints that were enabled with novalidate during the redefinition process. We were able to enable and validate all the constraints and it appears that the deadlock issue is resolved.
Thanks again for your assistance.
Edited by: mfpsdba on Feb 5, 2013 7:33 AM