Re: 9i tidbits (was: sorry for 9i)

"Boivin, Patrice J" wrote:

> Oracle is no longer going to make enhancements to the PL/SQL side of the
> database server, they are focusing entirely on the Java side. Apparently
> Oracle claims that in 8.1.7. java code runs 10x - 15x faster than PL/SQL.

I just installed it at work. I'll be benchmarking it in the next few days. :) If you're interested in the numbers, let me know. :)

>
> In 8.1.6. compiled java code is supposedly 5x - 6x faster than compiled
> PL/SQL. We did compile a java procedure in 8.1.6. as part of an exercise,
> and we found that compilation time was really slow, but the code executed as
> quickly as PL/SQL - at least we saw no difference.

I've got 8.1.6 numbers (not posted on Orageeks.com yet as I've been waiting for 8.1.7) already. From the top of my head, I recall that bytecode executed PL/SQL was fairly close to*compiled* C (I couldn't believe it myself!) but the 8.1.6 JavaVm was 5-10x slower than C and 1.5x-2x slower than a the same benchmark run within a true-blue JavaVM. Somehow I seriously doubt Oracle's claims here. :) If you want the hard numbers, e-mail me and I'll let you know as soon as I get them online.

> Oracle is trying to get rid of the tnsnames.ora file. They want people to
> use the Oracle Names Server, which is like a DNS server but for Service
> Names. (the term "SID" is now bad, the cool term is now "Service".
> Hopefully this won't confuse those of us who are talking about Oracle on NT,
> and we won't have to keep asking "Are you talking now about an NT service,
> or an Oracle service?").
>

You mean the Internet Directory, NOT Names, right?

> In 8i instances supposedly register themselves automatically with the
> server's listener, but our instructor was never able to make that work.
> Perhaps it will work in 9i.

That's because 8i changed the syntax of how this parameter works. See:

http://www.interealm.com/roby/technotes/net8i_listener_reg.html Received on Mon Nov 06 2000 - 17:29:55 CST