Re: A bit of fun

oracle-l-bounce@xxxxxxxxxxxxx wrote on 07/20/2004 12:11:08 PM:
> Neat!  I just ran this on 9.2.0.2 on Tru64 and the first run was 1.96
> seconds.  I don't have any other versions on the same host, so I ran it
> 2 more times and got 1.81 and 1.75 respectively.  From there it seemed
> to remain constant. 
> 
> Do you have native compilation enabled in 10g?  AFAICR, my research
> indicated that there are some parameters that default to interpreted
> rather than compiled PL/SQL.  I could be misremembering but I think that
> was the conclusion I came to.
> 

I haven't yet done anything with native compilation.  I'll try it
when I need another diversion.

Jared


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: