select status ,count(*) cnt from dba_objects where owner = upper('portal') and object_name like upper('sp_bip_user%') and object_type = upper('procedure') group by status STATUS CNT ------- ---------- INVALID 1 VALID 7 2 rows selected. select count(*) cnt from dba_procedures where owner = upper('portal') and object_name like upper('sp_bip_user%') CNT ---------- 7 1 row selected.왜 dba_procedures 에는 status가 없나 했음.