[ORACLE 9i] invalid 상태인 procedure는 dba_procedures에서 조회불가

|
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가 없나 했음.
And