Oracle Database 11g Release 2 (11.2.0.3) New Features

This Post contains descriptions of all of the features that are new to Oracle Database 11g Release 2 (11.2.0.3).

3.1 General

The following sections describe the new features for Oracle Database 11g Release 2 (11.2.0.3)

3.1.1 Oracle ACFS Snapshot Enhancements

The read/write snapshot feature for Oracle Automatic Storage Management Cluster File System (Oracle ACFS) adds support for fast creation of an Oracle ACFS snapshot image that can be both read and written without impacting the state of the Oracle ACFS primary file system hosting the snapshot images.

With this enhancement, you can test new versions of application software on production file data reflected in the read/write snapshot image without modifying the original production file system.

You can also run what-if scenarios on a real data set without modifying the original file system.

3.1.2 Oracle ACFS Security and Encryption Features

The Oracle Automatic Storage Management Cluster File System (Oracle ACFS) security feature provides realm-based security for Oracle ACFS.

The Oracle ACFS encryption feature enables data stored on disk (data-at-rest) to be encrypted.

Oracle ACFS security feature provides the ability to create realms to specify security policies for users or groups for accessing file system objects. The Oracle ACFS security feature provides finer-grained access control on top of the access control provided by the operating system.

Oracle ACFS encryption feature provides the ability to keep data in an Oracle ACFS file system in encrypted format to prevent unauthorized use of data in the case of data loss or theft.

3.1.3 Support for ACFS Replication and Tagging on Windows

Support for replication and tagging functionality is now available on the Windows platform.

Oracle Automatic Storage Management Cluster File System (Oracle ACFS) replication enables replication of Oracle ACFS file systems across the network to a remote site, providing disaster recovery capability for the file system.

Oracle ACFS tagging assigns a common naming attribute to a group of files. Oracle ACFS replication can use this tag to select files with a unique tag name for replication to a different remote cluster site. The tagging option avoids having to replicate an entire Oracle ACFS file system.

3.1.4 Oracle LogMiner Support for Binary XML

This feature extends Oracle LogMiner data type support to include support for XMLType columns and tables stored in binary format.

Oracle LogMiner can now be used with applications having XML stored using binary format.

See Also:Oracle Database Utilities for details

3.1.5 SQL Apply Support for Binary XML

This feature extends SQL Apply data type support to include support for XMLType columns and tables stored in binary format.

SQL Apply can now be used with applications having XML stored using binary format.

3.1.6 Oracle LogMiner Support for Object Relational Model

This feature extends Oracle LogMiner data type support to include support for XMLType columns and tables stored using the Object Relational (O/R) model.

Oracle LogMiner can now be used with applications having Oracle XML stored using the O/R model.

See Also:Oracle Database Utilities for details

3.1.7 SQL Apply Support for Object Relational Model

This feature extends SQL Apply data type support to include support for XMLType columns and tables stored using the Object Relational (O/R) model.

SQL Apply can now be used with applications having XML stored using the O/R model.

3.1.8 Deprecation of Obsolete Oracle XML DB Functions and Packages

The following Oracle XML DB constructs are deprecated in Oracle Database 11g Release 2 (11.2.0.3):

  • PL/SQL procedure DBMS_XDB_ADMIN.createRepositoryXMLIndex
  • PL/SQL procedure DBMS_XDB_ADMIN.XMLIndexAddPath
  • PL/SQL procedure DBMS_XDB_ADMIN.XMLIndexRemovePath
  • PL/SQL procedure DBMS_XDB_ADMIN.dropRepositoryXMLIndex
  • XML schema annotation (attribute) csx:encodingType
  • XMLIndex index on CLOB portions of hybrid XMLType storage, that is, on CLOB data that is embedded within object relational storage

These constructs are still supported in 11.2.0.3 for backward compatibility, but Oracle recommends that you do not use them in new applications.

See Also:Oracle XML DB Developer’s Guide for details

3.1.9 Oracle Warehouse Builder Support for Partition DML

In this release, Oracle Warehouse Builder (OWB) can now generate DML specific to manipulating database partitions. This allows OWB users to perform extract, transform, and load (ETL) operations with all types of partitioned tables.

This feature enables fuller exploitation of database resources and capabilities, and improves developer and DBA productivity by making these capabilities available from within OWB.

For additional information, see the Oracle Warehouse Builder documentation.

3.1.10 Enhanced Partitioning Support in Oracle Warehouse Builder

In this release, Oracle Warehouse Builder (OWB) exposes the full range of database partitioning types available up through Oracle Database 11g Release 2 (11.2.0.2). This allows OWB users to design and perform extract, transform, and load (ETL) operations with all types of partitioned tables.

This feature improves developer productivity by making these capabilities available from within OWB and enables fuller exploitation of database resources and capabilities.

For additional information, see the Oracle Warehouse Builder documentation.

3.1.11 Oracle Warehouse Builder External Table Data Pump Support

In this release, Oracle Warehouse Builder (OWB) exposes the database support for the ORACLE_DATAPUMP access driver. This enables OWB to use external tables to unload data to Data Pump export files and load from Data Pump export files through external tables in extract, transform, and load (ETL) mappings.

Use of Data Pump export files for moving bulk data is the recommended best practice for ETL into an Oracle data warehouse because it is faster than other methods (such as using database links) of moving data between Oracle databases.

For additional information, see the Oracle Warehouse Builder documentation.

3.1.12 Oracle Warehouse Builder External Table Preprocessor Support

In this release, Oracle Warehouse Builder (OWB) exposes the database support for the external table preprocessor.

The external table preprocessor enables more flexible handling of external table source files, such as compressed flat files or multiple files, from within extract, transform, and load (ETL) mappings.

For additional information, see the Oracle Warehouse Builder documentation.

3.1.13 Compressed Table and Partition Support in Oracle Warehouse Builder

In this release, Oracle Warehouse Builder (OWB) exposes the table-level and partition-level compression options of all Oracle Database releases up to Oracle Database 11g Release 2 (11.2.0.2). This allows OWB users to manage the compression of tables and individual partitions as part of the design of their sources and targets.

This feature improves developer productivity by eliminating the need to manage these options outside of OWB and enables fuller exploitation of database resources.

For additional information, see the Oracle Warehouse Builder documentation.

3.1.14 Support for PL/SQL Native Compilation

Oracle Warehouse Builder (OWB) now supports PL/SQL native compilation. With PL/SQL native compilation enabled, the PL/SQL statements in a PL/SQL unit are compiled into native code and stored in the catalog. The native code need not be interpreted at run time, therefore it runs faster.

PL/SQL native compilation provides the greatest performance gains for computation-intensive procedural operations, such as certain data warehouse computations that are usually not performed in set-based SQL.

http://download.oracle.com/docs/cd/E11882_01/server.112/e22487/chapter1_11203.htm

Advertisements


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s