 | | | PL/SQL delayed compilation | PL/SQL delayed compilation 2007-08-31 - By John Kanagaraj
Back
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 **
Edgar,<br><br><div><span class="gmail_quote"></span><blockquote class="gmail
_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0
.8ex; padding-left: 1ex;"><div>I have heart a mention of this feature in LewisC
podcast and also in Oracle 11g new feature white paper. Oracle white paper says
:
<br> </div>
<div> </div>
<div>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.<br><br></div></blockquote></div><br>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
<br><br>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:<br><br>select referenced_type, count(*)
from dba_dependencies
<br>group by referenced_type;<br><br>-- <br>John Kanagaraj <><<br>DB
Soft Inc<br><a href="http://www.linkedin.com/in/johnkanagaraj">http://www
.linkedin.com/in/johnkanagaraj</a><br><a href="http://jkanagaraj.wordpress.com">
http://jkanagaraj.wordpress.com</a> (Sorry - not an Oracle blog!)<br>** The
opinions and facts contained in this message are entirely mine and do not
reflect those of my employer or customers **
|
|
|