Shulou(Shulou.com)06/01 Report--

During the daily inspection of oracle, the following alarm is found in the alarm log:

First, it is found that the reason is that the database locks the table because the operation on the table is too frequent. Because the session is operating on the target table and has an exclusive lock, it is impossible to operate on the target table now.

Log in to the database with the administrator user and query the locked ID session:

1.select session_id from vault lockedobject object match-query the id number of session

2.select sid,serial#,username,osuer from v$session where sid= xx;-- xx is the session_id found in the previous step.

3. Get the sid and serial#. of the locked session

4. Execute alte system kill 'sid,serial#'

Third, after the session is closed, you can do what you want.

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.