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

Use oracle's job to call stored procedures regularly, such as the stored procedure is trapped in a dead loop or other reasons, the state of job is running all the time. At this point, the stored procedure is called manually, and the stored procedure cannot be executed because the table is locked. At this point, you need to stop job with the following command: BEGIN dbms_scheduler.stop_job (job_name = > 'GETHOLDS'); END

If the stored procedure still cannot be executed, you need to check whether the table of the stored procedure is locked by the process, find the process and kill it:

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

Alter system kill session '738 and 1429'

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.