Unlock a table
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Unlock a table

  1. #1
    Join Date
    Jan 2001
    Posts
    515
    I have a table that is locked. A procedure was running on this table when I killed the session. I have waited about a half hour and the table is still locked. Is there anyway I can unlock the table?

  2. #2
    Join Date
    Aug 2001
    Posts
    184
    is the session dead? if not, it is rolling back tx.
    OCP DBA 8i
    ocpwannabe@yahoo.com
    -----------------------------
    When in doubt, pick 'C'.

  3. #3
    Join Date
    Jan 2001
    Posts
    515

    I don't know.

    The procedure inserted records into a table and committed after every one. So even if it rolled back it would have been for only one record. Everytime I do a alter session kill it says that it is marked for kill but it isn't killed.

  4. #4
    Join Date
    Aug 2001
    Posts
    184
    check dba_blockers for blocking sessions
    OCP DBA 8i
    ocpwannabe@yahoo.com
    -----------------------------
    When in doubt, pick 'C'.

  5. #5
    Join Date
    Jan 2001
    Posts
    515

    this is what i get

    GCPRPRD>select * from dba_blockers;

    no rows selected

  6. #6
    Join Date
    Jan 2001
    Posts
    191
    Is this a production database or develop or testing database?

    When I have this problem in testing, the fast way is to shutdown abort. No one cares about data any way.


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