Oracle Action Table "Resource is busy, need to specify nowait" method of unlocking

Source: Internet
Author: User

Oracle Action Table "Resource is busy, need to specify nowait" method of unlocking

Problem:

When executing drop table table_name, the prompt "resource is busy, you need to specify NoWait"
PL/SQL is not responding due to a problem that can only be queried for setting the primary key and cannot be modified and deleted, so the table is locked for tb_project

Analysis:

Indicates that the TABLE_NAME table is locked by a user action and must be unlocked before proceeding

Solve:

1> This statement to query the session_id that is being locked:

SELECT session_id from V$locked_object,user_objects WHERE v$locked_object. object_id = user_objects. object_id

2> through the first step query to the session_id query serial#

SELECT serial# from v$session WHERE sid= ' session_id ' (here is the ' session_id ' queried above)

3> based on 1, 2 step query to SESSION_ID and serial# execute alter SYSTEM KILL SESSION ' 48,2476 ' (48 is session_id value, 2476 is serial# value)

Oracle Action Table "Resource is busy, need to specify nowait" method of unlocking

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.