Re: 10g Resource

On Fri, 06 Feb 2004 11:59:58 -0800, Daniel Morgan <damorgan_at_x.washington.edu> wrote:

>I have started posting 10g demos at the Puget Sound Oracle User
>Group web site.
>
>http://www.psoug.org
>
>Click on the Morgan's Library link.
>
>What I am doing is mirroring materials presented at the University
>of Washington classes I teach so each week I will be adding more
>material and updating what is on the site.
>
>BTW: In 10g ... if you want to drop a table ... don't try this:
>SQL> drop table mytable;
>At least not without reading the fine documentation first.

 Looks like there's a pile of useful new features in 10g; lots of reading to do now!

 The new PL/SQL optimiser strikes me as a particularly useful feature that hasn't been mentioned too often on the newsgroups yet (probably because it's evolutionary rather than revolutionary); will be interesting to see if it lives up to Oracle's claims of up to 2x improvements by flicking a switch.

 <http://otn.oracle.com/tech/pl_sql/htdocs/new_in_10gr1.htm>

 Given the complications introduced by C and C++ optimisation it's likely to be a bit more work than that. They do warn about this, in the 'Freedom, Order, and PL/SQL Optimization' whitepaper in the page above. But like the increased strictness of the 9i PL/SQL compiler vs. 8i it should help shake out dodgy code as a result, which is all good in the end. The new compiler warnings feature of PL/SQL should be particularly good in this respect too; AllRound Automation's PL/SQL Developer tool has had warnings in the last couple of versions, but they're limited in scope (since it has to parse the PL/SQL, which Oracle can do presumably do a better job at). Once they start coming from Oracle they can be picked up at build time, rather than just seen by the developers.

 Particularly need to find and understand all these alterations to existing syntax, rather than entirely new syntax. The recycle bin's effect on DROP TABLE you mention is a perfect example, since we're bound to have at least one release at work where we support both 9iR2 and 10gR1 - and we can't go putting 'drop table x purge' in an upgrade script that's supposed to run on 9i.

 Just waiting for the Linux port to be released now to have a play with it... wasn't it supposed to be this week?
 (Yes, I know, it'll be out when it's ready ;-) )

-- 
Andy Hassall <andy_at_andyh.co.uk> / Space: disk usage analysis tool
<http://www.andyh.co.uk> / <http://www.andyhsoftware.co.uk/space>