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

Problem: update a table of data, only a few hundred, and then very slow, has been executed, and then forced to return, re-execution is still the same, considering that it may be the problem of locking the table!

Resolve:

① first finds out which session is locked:

Select object_name,machine,s.sid,s.serial#

From v$locked_object l,dba_objects o, v$session s

Where l.object_id=o.object_id and l.session_id=s.sid

After finding out, I found that there were three objects!

② then kills all three objects one by one:

Alter system kill session '13pr 52136'

-- 13 here is found above. Sid,52136 is found out serial.

Then there was another problem. When I checked again, the session with sid 13 was still there, but the status was already killed. When I executed alter system kill session'13, 52136, I reported an error ORA-00031:session marked for kill (marking the session to be terminated).

The locked resources on the server database are still not released, so we can go to the server and kill the process!

First, find out the process number spid:

Select spid, osuser, s.program

From v$session spark vested process p

Where s.paddr=p.addr and s. Sidestep 13;-- spid=5162

Then kill the process according to the queried spid

1. Linux OS:kill-9 5162

2. Windows OS:orakill mars 5162, where mars is the instance name of the process to be killed!

Open cmd under windows and enter the command tasklist / svc to view the service name with PID 5162, that is, the instance name!

Here are three concepts:

SPID one by one system process id

Indicates the Porcess ID of the server process at the OS level, that is, the operating system process ID

PID one by one Oracle process id

It can be understood as Oracle's own use, Oracle process ID

SID one-to-one session identity, often used to join other columns

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.