Richard Foote wrote:
> "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
dbms_stats has 63, IIRC, new parameters and procedures. Statistics
collection has been changed in a big way.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Fri Aug 10 2007 - 10:48:50 CDT
