With Oracle 11g, as with every new release, there are too many new features to be able to cover all of them, so we'll look at just a few in the broad categories of:
and provide links for more information.
Oracle 11g Change Management EnhancementsThe most widely applicable enhancement in this area is what Oracle have dubbed Real Application Testing. The idea of this is to reduce the risk of change by allowing real production workloads to be
captured and then replayed on a test system to determine in advance the impact of hardware or software changes.
The ability to capture workloads was implemented in Oracle 10g, new in this release is the option to replay workloads.
The database replay feature also provides reporting to highlight any potential problems such as any errors encountered or any divergence in performance and recommend steps to resolve these problems.
Oracle Tips & Tricks to SKYROCKET Your Career!
If you're not already a subscriber you're missing out on a myriad of tips and techniques to help you become a better, faster, smarter developer. Subscribe now and ignite your career.
In terms of grid computing, Oracle 10g release 1 was for early adopters, 10g release 2 made it mainstream and 11g makes it easy and straightforward.
ASM (Automatic Storage Management) has been improved in terms of manageability, performance and automation. New ASM features include:
ADDM (Automatic Database Diagnostic Monitor) has been made cluster aware so that it can detect global i/o and interconnect problems.
Enhancements for data warehouses/business intelligence systems include new partitioning options, the full integration of OLAP with the database and enhanced data mining and predictive analytics.
Also new to 11g are cube-organised materialized views which enable cubes to be referenced in sql and the transparent rewrite of queries against relational tables to reference cubes instead.
Go to part 2 for a more detailed look at the data warehousing enhancements in 11g.
Changes in this area include enhancements to the infrastructure for handling large objects (LOBs), known as SecureFiles, enabling the compression and encryption of LOBs as well as automatic de-duplication. These changes make the handling of LOBs much easier and faster and reduce storage requirements.
Other examples of performance improvements include a new query results-caching feature which saves the results of queries in a separate area of the shared pool and will therefore be of benefit to frequently-executed queries. This cache area is also used to save the results of deterministic PL/SQL functions. See Oracle 11g SQL New Features for more details.
The other big improvement to PL/SQL is the auto-compilation to native code without the need for a separate C compiler. This will be of benefit to highly processor-intensive PL/SQL routines which may be of an order of magnitude faster.
Details on the new features can be found in the Oracle documentation available on OTN.
Looking for Oracle Training?
With our partners we offer instructor-led Oracle training on or off site in the UK as well as training via the Internet. See here for Oracle training in the UK. Or contact us for details of our on-line training courses.