DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 1999

    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


  2. #2
    Join Date
    Dec 2000
    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).


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.