lock on the table - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: lock on the table

  1. #11
    Join Date
    Sep 2002
    Posts
    411
    no no no

    if you kill the session from the O/S side, the process is gone right away and it's not suppose to mark to kill. I got rid of the process from the O/S side but I still see the lock on the table, that's right I don't understand.

  2. #12
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by mike2000
    no no no

    if you kill the session from the O/S side, the process is gone right away and it's not suppose to mark to kill. I got rid of the process from the O/S side but I still see the lock on the table, that's right I don't understand.
    If the session still has the table locked, I would say that proves your theory wrong.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #13
    Join Date
    Mar 2002
    Posts
    36
    yeahhh v$locked_objects is a fastest way to solve lock situation....Ask your DBA do it for you....
    nguyenjl

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