Re: PL/SQL delayed compilation
- From: Dan Norris <dannorris@xxxxxxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 31 Aug 2007 14:55:40 -0700 (PDT)
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:
