In the oracle database, the insert and update operations on the data table cannot be performed in the oracle database, and the data table cannot execute the update statement because the data table is locked by other users. The solution is as follows: www.2cto.com first, run the following SQL statement:
Select * from v $ session t1, v $ locked_object t2 where t1.sid = t2.SESSION _ ID; or select sess. sid, sess. serial #, lo. oracle_username, lo. OS _user_name, ao.
Object_name, lo. locked_mode from v $ locked_object lo, dba_objects ao,
V $ session sess where ao. object_id = lo. object_id and lo. session_id = sess. sid; then, find different users in the query results, and then run the following statement to kill unnecessary users: www.2cto.com alter system kill session 'sid, seria #', where sid and seria # are redundant users, and finally execute the SQL statement in the first step. If no query result exists, the solution is completed.