Oracle function (stored procedure) or table Save card dead, Locked solution

1. If the function is locked, then there must be a process using the function

Select b.sid,b.serial# from Dba_ddl_locks A, v$session b Where a.session_id = b.sid and A.name = ' function name or table name ';

2. Kill processes using commands in Oracle

Alter system kill session ' sid,serial# ';

3. If you encounter a situation that cannot be killed in Oracle, the process is killed at the OS level

Select spid, Osuser, s.program from V$session s,v$process p where s.paddr=p.addr and s.sid=1715

Kill-9 PID

Oracle function (stored procedure) or table Save card dead, Locked solution