I have a table which has no foreign Key constraint as such but whenever I try to delete rows . I get an error of DEADLOCK error 60 , waiting for resource . I am not able to find any reason for this since there is no referential integrity .
There are however a few procedure which are accessing this table but their status is INVALID. can they be a reason for deadlock
Check v$access to see if any other session is using that table?
You can also check the v$lock, v$locked_object to identify locks in your system.
Alternatively you can find some scripts that list locks in your system.
You can find one such script at : [url]http://www.lacroe.com[/url] (click on code library).
Click Here to Expand Forum to Full Width