locks
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: locks

  1. #1
    Join Date
    Jun 2001
    Posts
    316
    It seems one record of 1 table is been locked by some1?
    How do i see which user is that u has loced it and how do i remove this lock?
    thanx in advance

  2. #2
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316
    select * from v$access - will show you what objects are being accessed by what users -this will be the place to start.

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