Re: 11g Released Today

"DA Morgan" <damorgan_at_psoug.org> wrote in message news:1186710538.837315_at_bubbleator.drizzle.com...
> Oracle released 11.1.0.6 on Linux today.
>
> The links for the 11g docs are on the psoug.org website ... click on the
> 11g icon (top center)
>
> The link to the download page is just below it.
>
> Morgan's Library has now been updated and contains substantial new 11g
> functionality including but not limited to:
>
> New native compilation capabilities
>
> New compound table triggers
>
> New CONTINUE statement for loops
>
> New DBMS_AUTO_TASK_ADMIN package
>
> New DBMS_HPROF hierarchical profiler ... and this is a gem
>
> New DBMS_NETWORK_ACL built-in packages that affect UTL_SMTP, UTL_MAIL,
> UTL_HTTP, UTL_INADDR and UTL_TCP capabilities
>
> More than 60 new parameters and procedures in DBMS_STATS
>
> New Result Cache and DBMS_RESULT_CACHE built in package and associated
> hint
>
> New FLASHBACK ARCHIVE that extends FLASHBACK QUERY, FLASHBACK TABLE, and
> FLASHBACK VERSION phenomenally. This is also referred to in market-speak
> as TOTAL RECALL: And it is.
>
> New Table Trigger FOLLOWS clause
>
> New INVISIBLE indexes
>
> A demonstration using the PARENT Correlation name with instead-of triggers
>
> New PL/SQL object settings
>
> New, and greatly enhanced, warning capabilities with DBMS_WARNING.
>
> New VIRTUAL table columns
>
> And if anyone cares to know ... this is not a promotional message for
> Morgan's Library as everyone here already knows it exists. This is a
> blatant promotional message for 11gR1 which I have now worked with for
> months and which is a wonderful enhancement that will keep Oracle the
> leader in commercial databases and keep all of us employed.
>
> In the my lab I currently have 11g running on five servers and have
> a 2 node RAC cluster that has been up for more than a month without a
> single issue.
>
> Thanks Mr. Townsend. Thanks. Mr. Hardie. And thanks to everyone that
> works with you. Great job.
> --

Hi Daniel

Hidden away is a little enhancement that now allows you to collect histogram information on combined multiple columns or column groups. This provides the CBO with information on the distribution of data between columns so that it can correctly calculate the cardinality of a predicate when two (or more) columns are specified but the distribution of data across values is not evenly distributed. Classic example being the number of Gemini's born in January can now be correctly calculated.

I've been begging for this capability for years and it has finally arrived. Now if 12g it can just collect these statistics across different tables, well I might be tempted to go live with Release 1 !!

The ability to open a standby database in read-only mode and have it in recovery mode at the same time is very very nice as well.

Looking forward to the AIX version of 11g ...

Cheers

Richard Received on Fri Aug 10 2007 - 07:32:40 CDT