Re: PL/SQL delayed compilation

Edgar,

I have heart a mention of this feature in LewisC podcast and also in Oracle
> 11g new feature white paper. Oracle white paper says:
>
> With Oracle Database 11g, both patch set and release upgrades are now
> significantly faster through the use of parallelism and delayed compilation
> of PL/SQL objects.
>
>

Apparently, Oracle Database 11g does this by recording dependency information at the granularity of the element within the object rather than at the whole object. For example dependencies on a procedure within a package is tracked rather than dependency on the package itself. Hence, if you

This is what I know - I am sure the Gurus would like to comment. 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;

-- 
John Kanagaraj <><
DB Soft Inc
http://www.linkedin.com/in/johnkanagaraj
http://jkanagaraj.wordpress.com (Sorry - not an Oracle blog!)
** The opinions and facts contained in this message are entirely mine and do
not reflect those of my employer or customers **

--
http://www.freelists.org/webpage/oracle-l