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 **

Other related posts: