Oracle® Database New Features Guide 11g Release 2 (11.2) Part Number E22487-02 |
|
|
PDF · Mobi · ePub |
This chapter contains descriptions of all of the features that are new to Oracle Database 11g Release 2 (11.2.0.3).
The following sections describe the new features for Oracle Database 11g Release 2 (11.2.0.3)
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.
See Also:
Oracle Automatic Storage Management Administrator's Guide for details
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.
See Also:
Oracle Automatic Storage Management Administrator's Guide for details
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.
See Also:
Oracle Automatic Storage Management Administrator's Guide for details
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
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.
See Also:
Oracle Data Guard Concepts and Administration for details
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
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.
See Also:
Oracle Data Guard Concepts and Administration for details
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
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.
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.
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.
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.
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.
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.
For additional information, see the Oracle Warehouse Builder documentation.