How ORACLE queries the locked table and how to unlock the release session

Background database operation of a table is found to have been out of suspended animation state, may be that the table is locked by a user, followed by a detailed description of your query is locked table and how to unlock, interested in you can refer to, hope can help you

ORACLE EBS operates on a form interface, or when a background database operates on a table and finds that it has been in "suspended animation" state, possibly because the table is locked by one user, which prevents other users from continuing the operation

-- lock table Query SQL SELECT object_name    from WHERE l. object_id = O. object_id and =　

Locate the locked table and unlock it

　　

How ORACLE queries the locked table and how to unlock the release session