Shulou(Shulou.com)05/31 Report--

This article is about how to solve the problem of "records being locked by another user" in Oracle database. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

1. First, let's take a look at why it is locked:

The database is a shared resource used by multiple users. When multiple users access data concurrently, multiple transactions will access the same data at the same time in the database. If there is no control over concurrent operations, incorrect data may be read and stored, and the consistency of the database will be destroyed.

Locking is a very important technology to realize database concurrency control. When a transaction makes a request to the system and locks it before operating on a data object. After locking, the transaction has some control over the data object, and other transactions cannot update the data object until the transaction releases the lock.

There are two basic types of locks in the database: Exclusive Locks (X lock) and shared lock (Share Locks, S lock). When an exclusive lock is added to a data object, it cannot be read or modified by other transactions. Data objects with shared locks can be read by other transactions, but cannot be modified. The database uses these two basic lock types to control the concurrency of database transactions.

2. Solution:

Log in to the database with the administrator account and execute sql:

SELECT object_name, machine, s.sid, s.serial# FROM gv$locked_object l, dba_objects o, gv$session s WHERE l.object_id = o.object_id AND l.session_id = s.sid

Find the corresponding locked table to execute:

-- release SESSION SQL:-- alter system kill session 'sid, serial#'; ALTER system kill session' 23,1647; Thank you for reading! This is the end of this article on "how to solve the problem that Oracle database records are locked by another user". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it out for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.