Oracle Consulting and Training
For Better, Faster, Smarter
Oracle 11g New Features Overview
There are far too many Oracle 11g new features for all of them to be covered in depth even if we were to write a book on them), so this is just a bird’s eye view of a few of the enhancements and new features along with links to more information in the following areas: • performance • grid computing • data warehousing/business intelligence • change management • SQL • PL/SQLOracle 11g Performance enhancements
Performance enhancements worth mentioning include
those made to SecureFiles (the large objects (LOB)
infrastructure), the new results cache for SQL and
PL/SQL and PL/SQL native compilation.
Oracle SecureFiles enhancements
LOBs can now be compressed and encrypted and de- duplicated automatically, thereby reducing LOB storage requirements and making their handling much easier and faster.Query results cache
Oracle 11g now enables the results of deterministic PL/SQL functions and SQL queries to be saved in the results cache area of the shared pool. The results cache is enabled via the result_cache_mode system parameter which has two values: • MANUAL - result caching is activated by a query hint • FORCE - all results are cached (when it is valid to do so). The result_cache_mode parameter can be modified at the session and system levels. The size of the results cache is set by the result_cache_max_size system parameter.PL/SQL compilation
Auto-compilation of Oracle 11g PL/SQL to native code without the need for a separate C compiler is the other big performance enhancement. Highly processor-intensive PL/SQL routines may be of an order of magnitude faster than in 10g. See the Oracle documentation for more details .Oracle 11g Change Management Enhancements
One of the more significant enhancements in this area is what Oracle call Real Application Testing. This feature reduces the risk of change by allowing real (i.e. production) workloads to be captured and then replayed on a test system to determine the impact of hardware or software changes. The database replay feature also includes reporting to highlight potential issues such as errors encountered or divergence in performance and any recommend solutions.Grid Computing New Features
Oracle 11g makes grid computing easy and straight forward with the enhancements to ADDM and ASM.ASM (Automatic Storage Management) enhancements
• a fast mirror resync when a failed disk is brought back online • support for heterogeneous environments • rolling upgrade to maintain database availability during patching/upgrades • support for databases of 100s of TB in sizeADDM (Automatic Database Diagnostic Monitor) enhancement
This has been made cluster aware in 11g so that it can detect global i/o and interconnect problems.Oracle 11g Data Warehousing New Features
Enhancements for data warehouses and business intelligence systems in 11g include three new partitioning options, the full integration of OLAP with the database and new data warehousing features in SQL.New Partitioning Options
• auto-range partitioning - eliminates the need to manually create new partitions at specific time intervals • composite partitioning - list-hash, list-list, list-range and range-range partitioning • partitioning by reference (child table references primary key of parent)Integration of OLAP with the database
Oracle 11g introduces cube-organised materialized views, enabling cubes to be referenced in sql and the transparent rewrite of queries against relational tables to reference cubes instead. --------------------------------------- Looking to sky-rocket productivity, save time and reduce costs?Training is a highly cost-effective and proven method of boosting productivity. Smartsoft offers instructor-led training in Oracle and related technologies on or off site in cities across the UK as well as self-study online training. See our scheduled Oracle training courses, or let us know your requirements. Oracle tips and tricks Subscribe to our newsletter, jam-packed full of tips and tricks to help you slash costs, sky- rocket productivity and make your systems better, faster and smarter. © Smartsoft Computing Ltd, Bristol, England Need help? Contact Us This site uses woopra.com to gather statistical information about our visitors. This data is aggregated to show industry trends (such as browser share). However, this data shall be the average of many thousands of visits and is in no way linked to individuals. View woopra privacy policy. View Smartsoft privacy policy Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.
For Better,
Faster, Smarter
Oracle Consulting
and Training
Oracle 11g New Features Overview
There are far too many Oracle 11g new features for all of them to be covered in depth even if we were to write a book on them), so this is just a bird’s eye view of a few of the enhancements and new features along with links to more information in the following areas: • performance • grid computing • data warehousing/business intelligence • change management • SQL • PL/SQLOracle 11g Performance enhancements
Performance
enhancements worth
mentioning include those
made to SecureFiles (the
large objects (LOB)
infrastructure), the new
results cache for SQL and
PL/SQL and PL/SQL
native compilation.
Oracle SecureFiles
enhancements
LOBs can now be compressed and encrypted and de-duplicated automatically, thereby reducing LOB storage requirements and making their handling much easier and faster.Query results cache
Oracle 11g now enables the results of deterministic PL/SQL functions and SQL queries to be saved in the results cache area of the shared pool. The results cache is enabled via the result_cache_mode system parameter which has two values: • MANUAL - result caching is activated by a query hint • FORCE - all results are cached (when it is valid to do so). The result_cache_mode parameter can be modified at the session and system levels. The size of the results cache is set by the result_cache_max_size system parameter.PL/SQL compilation
Auto-compilation of Oracle 11g PL/SQL to native code without the need for a separate C compiler is the other big performance enhancement. Highly processor-intensive PL/SQL routines may be of an order of magnitude faster than in 10g. See the Oracle documentation for more details .Oracle 11g Change Management Enhancements
One of the more significant enhancements in this area is what Oracle call Real Application Testing. This feature reduces the risk of change by allowing real (i.e. production) workloads to be captured and then replayed on a test system to determine the impact of hardware or software changes. The database replay feature also includes reporting to highlight potential issues such as errors encountered or divergence in performance and any recommend solutions.Grid Computing New Features
Oracle 11g makes grid computing easy and straight forward with the enhancements to ADDM and ASM.ASM (Automatic Storage Management) enhancements
• a fast mirror resync when a failed disk is brought back online • support for heterogeneous environments • rolling upgrade to maintain database availability during patching/upgrades • support for databases of 100s of TB in sizeADDM (Automatic Database Diagnostic Monitor) enhancement
This has been made cluster aware in 11g so that it can detect global i/o and interconnect problems.Oracle 11g Data Warehousing New Features
Enhancements for data warehouses and business intelligence systems in 11g include three new partitioning options, the full integration of OLAP with the database and new data warehousing features in SQL.New Partitioning Options
• auto-range partitioning - eliminates the need to manually create new partitions at specific time intervals • composite partitioning - list-hash, list-list, list-range and range-range partitioning • partitioning by reference (child table references primary key of parent)Integration of OLAP with the database
Oracle 11g introduces cube-organised materialized views, enabling cubes to be referenced in sql and the transparent rewrite of queries against relational tables to reference cubes instead. --------------------------------------- Looking to sky-rocket productivity, save time and reduce costs?Training is a highly cost-effective and proven method of boosting productivity. Smartsoft offers instructor-led training in Oracle and related technologies on or off site in cities across the UK as well as self-study online training. See our scheduled Oracle training courses, or let us know your requirements. Oracle tips and tricks Subscribe to our newsletter, jam-packed full of tips and tricks to help you slash costs, sky-rocket productivity and make your systems better, faster and smarter. © Smartsoft Computing Ltd, Bristol, England Need help? Contact Us This site uses woopra.com to gather statistical information about our visitors. This data is aggregated to show industry trends (such as browser share). However, this data shall be the average of many thousands of visits and is in no way linked to individuals. View woopra privacy policy. View Smartsoft privacy policy Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.
