Oracle stored procedure compilation card-dead Solution

Here's how to fix it:

1: Check V$db_object_cache

SELECT * from V$db_object_cache WHERE name= ' cux_oe_order_rpt_pkg ' and locks!= ' 0 ';

Note: Cux_oe_order_rpt_pkg is the name of the stored procedure.

Discover locks=2

2: Find the SID value by object

Select/*+ rule*/SID from v$access WHERE object= ' cux_oe_order_rpt_pkg ';

Note: Cux_oe_order_rpt_pkg is the name of the stored procedure.

3: Check sid,serial#

SELECT sid,serial#,paddr from v$session WHERE sid= ' SID ' just found;

4:alter system kill session ' SID value, serial# value ' immediate;

Oracle stored procedure compilation card-dead Solution