Native Compilation Pros and Cons

[Michael42]

Hello,

Are there any reasons you could share as to why one would not use native compilation of PL/SQL code in Oracle 10g?

I would like to know the good and bad, i.e. the "entire package deal" on this topic.

Thanks,

Michael42

 

[SantaMufasa]

So that we answer the "right" question for you, Michael, could you please post code examples that produce the various "treatments" of PL/SQL code that you are evaluating/comparing? (By "treatments", I mean, for example, "native compilation", "code interpretation", et cetera.)

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]