Re: PL/SQL delayed compilation

From 11g:
REFERENCED_TYPE      COUNT(*)
------------------ ----------
SEQUENCE                  169
OPERATOR                  133
PROCEDURE                 120
PACKAGE                 17653
LIBRARY                   367
TYPE BODY                  25
NON-EXISTENT               85
XML SCHEMA                120
JAVA CLASS              73891
TABLE                   17769
FUNCTION                  581
VIEW                     8576
SYNONYM                  2696
EVALUATION CONTXT          22
INDEXTYPE                  10
TYPE                    10894

16 rows selected.

From 10g:
REFERENCED_TYPE     COUNT(*)
----------------- ----------
SEQUENCE                 110
PROCEDURE                 35
OPERATOR                  91
PACKAGE                10912
LIBRARY                  326
RULE SET                   2
PACKAGE BODY               2
NON-EXISTENT            3119
XML SCHEMA                15
TYPE BODY                 25
TABLE                  11685
VIEW                    6384
SYNONYM                 1383
FUNCTION                 344
EVALUATION CONTXT         23
JAVA CLASS             64388
INDEXTYPE                  8
TYPE                    7428

18 rows selected.

SQL>

Not much difference

----- Original Message ----
From: John Kanagaraj <john.kanagaraj@xxxxxxxxx>

...Maybe someone with a 11g database can post the description/selected contents 
of DBA_DEPENDENCIES and run the query below:

select referenced_type, count(*) from dba_dependencies 

group by referenced_type;

Other related posts: