Oracle 11gR2 新特性 概述

官网的说明链接如下：

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

一. 11.2.0.1新特性

This chapter containsdescriptions of all of the features that are new to Oracle 11gDatabase,Release 2. This chapter contains the following sections:

(1)ApplicationDevelopment

(2)Availability

(3)BusinessIntelligence and Data Warehousing

(4)Clustering

(5)DatabaseOverall

(6)Diagnosability

(7)Performance

(8)Security

(9)ServerManageability

(10) UnstructuredData Management

1.1Application Development

The followingsections describe the new application development features for Oracle Database11gRelease 2 (11.2).

1.1.1OracleApplication Express

The following sections describe OracleApplication Express features.

（1）ApplicationDate Format

（2）Custom Themes

（3）Declarative BLOB Support

（4）DocumentedJavaScript Libraries

（5）EnhancedReport Printing

（6）FormsConversion

（7） ImprovedSecurity

（8）InteractiveReporting Region

（9）Runtime-OnlyInstallation

1.1.2OtherGeneral Development Features

The followingsections describe new features in the areas of OCI, Pro*C, JDBC, and otherdevelopment APIs.

（1）Support WITHHOLD Option for CURSOR DECLARATION in Pro*C

（2）Pro*C Supportfor 8-Byte Native Numeric Host Variable for INSERT and FETCH

（3）Pro*COBOLSupport for 8-Byte Native Numeric Host Variable for INSERT and FETCH

（4）JDBCSupport for Time Zone Patching

（5）JDBCSupport for SecureFile Zero-Copy LOB I/O and LOB Prefetching

（6）OCISupport for 8-Byte Integer Bind/Define

1.2Availability

The focus ofthis Availability section is aimed towards providing capabilities that keep theOracle database available for continuous data access, despite unplannedfailures and scheduled maintenance activities. These various capabilities formthe basis of Oracle Maximum Availability Architecture (MAA), which is theOracle blueprint for implementing a highly available infrastructure usingintegrated Oracle technologies.

1.2.1Backupand Recovery

The followingsections describe new features in this release that provide improvements in thearea of backup and recovery.

（1）AutomaticBlock Repair

Automatic blockrepair allows corrupt blocks on the primary database or physical standbydatabase to be automatically repaired, as soon as they are detected, bytransferring good blocks from the other destination. In addition,RECOVERBLOCKis enhanced to restore blocks from a physical standby database. Thephysical standby database must be in real-time query mode.

--当在主库或者物理standby库上检测到坏块时，会自动对这些坏块进行修复。

This featurereduces time when production data cannot be accessed, due to block corruption,by automatically repairing the corruptions as soon as they are detected inreal-time using good blocks from a physical standby database. This reducesblock recovery time by using up-to-date good blocks from a real-time,synchronized physical standby database as opposed to disk or tape backups orflashback logs.

（2）Backupto Amazon Simple Storage Service (S3) Using OSB Cloud Computing

Oracle nowoffers backup to Amazon S3, an internet-based storage service, with the OracleSecure Backup (OSB) Cloud Module. This is part of the Oracle Cloud Computingoffering.

This featureprovides easy-to-manage, low cost database backup to Web services storage,reducing or eliminating the cost and time to manage an in-house backupinfrastructure.

--使用OSB 可以将DB 备份到amazon S3 存储上。

（3）DUPLICATEWithout Connection to Target Database

DUPLICATEcanbe performed without connecting to a target database. This requires connectingto a catalog and auxiliary database.

The benefit isimproved availability of aDUPLICATEoperation by not requiringconnection to a target database. This is particularly usefulforDUPLICATEto a destination database where connection to thetarget database may not be available at all times.

--duplicate 可以在连接到catalog 和 auxiliary 库上进行工作，而不需要在连到target db上。

（4）EnhancedTablespace Point-In-Time Recovery (TSPITR)

Tablespace point-in-time recovery (TSPITR)is enhanced as follows:

--TSPITR 得到如下的增强：

1)You now have the ability torecover a dropped tablespace.

2)TSPITR can be repeated multipletimes for the same tablespace. Previously, once a tablespace had been recoveredto an earlier point-in-time, it could not be recovered to another earlierpoint-in-time.

3)DBMS_TTS.TRANSPORT_SET_CHECKisautomatically run to ensure that TSPITR is successful.

4)AUXNAMEis no longer usedfor recovery set data files.

This feature improves usability withTSPITR.

（5）NewDUPLICATE Options

The following are new options fortheDUPLICATEcommand:

--Duplicate 增加选项：

1）NOREDO

NOREDOindicatesthat archive logs are not applied. Because targetless DUPLICATE does notconnect to the target database, it cannot check if the database is runninginNOARCHIVELOGmode. It can also be used during regular duplicationto force a database currently inARCHIVELOGmode to be recoveredwithout applying archive logs (for example, because it was inNOARCHIVELOGmodeat the point-in-time it is being duplicated).

--noredo 指定archive logs 不被应用。

2）UNDOTABLESPACE <tsname> [ , <tsname> ... ]

When notconnected to a recovery catalog and not connected to an open target database,RMAN cannot obtain the list of tablespaces with undo segments, therefore, youmust specify them with this clause.

--当连接到recover catalog 或连接时数据库没有open，在这种情况下，RMAN不能获取undo segement的表空间信息，这时就需要指定这个选项。

（6）New SET NEWNAME Clauses and Format Options

The followingare new clauses and format options for theSET NEWNAMEcommand:

1）A singleSET NEWNAMEcommand can beapplied to all files in a tablespace, or for all files in the database. For example:

SET NEWNAME FOR TABLESPACE <tsname>TO <format>;

Or,

SET NEWNAME FOR DATABASE TO <format>;

2）New format identifiers forSET NEWNAME...<format>are as follows:

%U： Uniqueidentifier.data_D-%d_I-%I_TS-%N_FNO-%f

%b： UNIX base name of the originaldata file name. For example, if the original data file namewasORACLE_HOME/data/tbs_01.f, then%bistbs_01.f.

The benefit is improved flexibilityofRESTORE,DUPLICATE, and TSPITR.

（7）Tablespace Checks in DUPLICATE

TheDUPLICATE...TABLESPACEandDUPLICATE...SKIP TABLESPACEcommands now perform the following initial checks:

--执行duplicate tablespace时会执行如下的initial checks:

1）Excluded tablespaces are checked tosee if they contain any objects owned bySYS.

2）DBMS_TTS.TRANSPORT_SET_CHECKisrun to ensure that the set of tablespaces being duplicated are self-containedbefore the actual duplicate process.

These checks arenot possible for a targetlessDUPLICATEas they are required to berun at the target database.

This featureimproves usability of DUPLICATE. Any tablespace issues are immediatelyidentified prior to commencement of the actual duplicate operation.

1.2.2OnlineApplication Maintenance and Upgrade

The following sections describe onlineapplication maintenance and upgrade features.

（1）Edition-basedRedefinition

（2）EnhanceCREATE or REPLACE TYPE to Allow FORCE

（3）Fine-GrainedDependencies for Triggers

（4）IGNORE_ROW_ON_DUPKEY_INDEXHint for INSERT Statement

1.2.3OracleData Guard

The followingsections describe new features in this release that provide improvements inOracle Data Guard.

（1）CompressedTable Support in Logical Standby Databases and Oracle LogMiner

Compressedtables (that is, tables with compression that support both OLTP and direct loadoperations) are supported in logical standby databases and Oracle LogMiner.

With support forthis additional storage attribute, logical standby databases can now providedata protection and reporting benefits for a wider range of tables.

（2）ConfigurableReal-Time Query Apply Lag Limit

A physicalstandby database can be open for read-only access while redo apply is activeonly if the Oracle Active Data Guard option is enabled. This capability isknown as real-time query.

--物理standby 可以已read-only 的方式进行访问。

ThenewSTANDBY_MAX_DATA_DELAYsession parameter can be used to specify asession-specific apply lag tolerance, measured in seconds, for queries issuedby non-administrative users to a physical standby database that is in real-timequery mode.

--新的STANDBY_MAX_DATA_DELAY 参数可以用来指定lag的间隔，单位是秒。

This capabilityallows queries to be safely offloaded from the primary database to a physicalstandby database, because it is possible to detect if the standby database hasbecome unacceptably stale.

（3）IntegratedSupport for Application Failover in a Data Guard Configuration

Applicationsconnected to a primary database can transparently failover to the new primarydatabase upon an Oracle Data Guard role transition. Integration with FastApplication Notification (FAN) provides fast failover for integrated clients.

Flexibility andmanageability of disaster recovery configurations using Oracle Data Guard isimproved.

（4）SupportUp to 30 Standby Databases

The number ofstandby databases that a primary database can support is increased from 9 to 30in this release.

The capabilityto create 30 standby databases, combined with the functionality of the OracleActive Data Guard option, allows the creation of reader farms that can be usedto offload large scale read-only workloads from a production database.

--在Oracle 10g中最多支持9个standby，在11g，最多可以支持30个standby。

1.3Business Intelligence andData Warehousing

The followingsections describe new Business Intelligence and Data Warehousing features forOracle Database 11gRelease 2 (11.2).

1.3.1ImprovedAnalytics

The following sectionsdescribe new and improved analytical capabilities in this release.

（1）AnalyticFunctions 2.0

（2）RecursiveWITH Clause

1.3.2Improved Data Loading

The followingsections describe new and improved data loading capabilities in this release.

（1）EXECUTEPrivilege for DIRECTORY Objects

（2）PreprocessingData for ORACLE_LOADER Access Driver in External Tables

1.3.3Improved Partitioning

The followingsections describe new and improved partitioning capabilities in this release.

（1）AllowVirtual Columns in the Primary Key or Foreign Key for Reference Partitioning

（2）System-ManagedIndexes for List Partitioning

1.3.4Improved Performance andScalability

The followingsections describe new and improved performance and scalability capabilities inthis release.

（1）In-MemoryParallel Execution

（2）MinimalEffort Parallel Execution - Auto Degree of Parallelism (DOP) and Queuing

（3）TheDBMS_PARALLEL_EXECUTE Package

（4）SignificantPerformance Improvement of On-Commit Fast Refresh

1.3.5OracleWarehouse Builder

The following sections describeimprovements to the extraction, transformation, and loading (ETL) capabilitiesavailable with Oracle Warehouse Builder (OWB).

（1）AdvancedFind Support in Mapping Editor

（2）BusinessIntelligence Tool Integration

（3）Copyand Paste of Operators and Attributes in Mapping Editor

（4）CurrentConfiguration Dropdown List in Design Center Toolbar

（5）EnhancedSupport for Flat File Imports

（6）EnhancedTable Function Support

（7）ExpertsAvailable in Editor Menu

（8）ExpressionEditing in Operator Edit Dialog

（9）Groupingand Spotlighting of Objects in Mapping Editor

（10）ImprovedManagement of Locations Registered in Multiple Control Centers

（11）ImprovedUser Interface for Managing Locations

（12）KeyLookup Operator Enhancements

（13）MappingDebugger Enhancements

（14）NewJDeveloper-Style User Interface

（15）OperatorReferences Included in Generated PL/SQL Code

（16）QuickMapper

（17）RepositoryBrowser Changes

（18）SimplifiedOracle Warehouse Builder Repository Upgrades

（19）Supportfor Extracting Data From Tables Containing LONG Data Type

（20）Supportfor Subqueries in Join Operator

1.4Clustering

The followingsections describe new clustering features for Oracle Database 11gRelease2 (11.2).

这部分的详细内容，也可以参考：

Oracle 11gR2RAC 新特性说明

http://blog.csdn.net/tianlesoftware/article/details/5982972

1.4.1OracleReal Application Clusters Ease-of-Use

This release ofOracle Real Application Clusters (Oracle RAC) provides many features todramatically simplify installation and on-going management of a cluster andOracle RAC database, making it easy for the novice to adopt clustering andOracle RAC and reap the benefits of this technology.

The following sections describe ease-of-usefeatures for Oracle RAC.

（1）ConfigurationAssistants Support New Oracle RAC Features

（2）EnhancedCluster Verification Utility

（3）Integrationof Cluster Verification Utility and Oracle Universal Installer

（4）ClusterTime Service

The Cluster TimeService synchronizes the system time on all nodes in the cluster. Asynchronized system time across the cluster is a prerequisite to install andsuccessfully run an Oracle cluster.

This featuresimplifies management, maintenance, and support of an Oracle cluster and anOracle RAC environment by providing an out-of-the-box time server. It alsoimproves the reliability of Oracle RAC environments.

（5）OracleCluster Registry (OCR) Enhancements

There have beenimprovements in this release in the way the Oracle Cluster Registry (OCR) isaccessed. These improvements include:

1）Faster relocation of services onnode failure.

2）Support for up to 5 copies of theOCR for improved availability of the cluster.

3）Storage of OCR in Automatic StorageManagement (ASM).

The tools tomanage the OCR have changed to support the new management options.Theseenhancements improve performance in Oracle Clusterware and Oracle RealApplication Clusters environments and provide easier management of the clusterthrough consistent storage management automation

（6）GridPlug and Play (GPnP)

（7）OracleRestart

Oracle Restartimproves the availability of your single-instance Oracle database. OracleRestart automatically restarts the database instance, the Automatic StorageManagement (ASM) instance, the listener, and other components after a hardwareor software failure or whenever your database host computer restarts. ServerControl (SRVCTL) is the command line interface to manage Oracle processes thatare managed by Oracle Restart on a standalone server.

This featureprovides improved reliability and automated management of a single-instanceOracle database and the management of any process or application running on thedatabase server.

（8）Policy-Based Cluster andCapacity Management

（9）ImprovedClusterware Resource Modeling

（10）Role-SeparatedManagement

（11）AgentDevelopment Framework

（12）Zero Downtime Patching forOracle Clusterware and Oracle RAC

The patching ofOracle Clusterware and Oracle Real Application Clusters can now be completedwithout taking the entire cluster down. Patchsets are now installed asout-of-place upgrades to the Oracle Grid infrastructure for a cluster software(Oracle Clusterware and Automatic Storage Management) and Oracle Database.

Now you canreduce your unplanned downtime of clustered databases and applications runningin a cluster.

（13）Enterprise Manager-BasedClusterware Resource Management

（14）EnterpriseManager Provisioning for Oracle Clusterware and Oracle Real ApplicationClusters

（15）EnterpriseManager Support for Grid Plug and Play

（16）EnterpriseManager Support for Oracle Restart

（17）ConfigurationAssistant Support for Removing Oracle RAC Installations

（18）OracleUniversal Installer Support for Removing Oracle RAC Installations

The installercan clean up a failed Oracle Clusterware installation or upgrade of anenvironment prior to reattempting the operation. This ensures that thereattempted operation is done over a clean environment, thereby eliminating thechances of errors related to environmental inconsistencies.

Easily cleaningup an environment provides improved Oracle RAC manageability and deployment.

（19）Improved DeinstallationSupport With Oracle Universal Installer

The installationof Oracle Clusterware and Oracle RAC now have recovery points. If a failureoccurs during installation, you can rollback to the closest recovery point andrestart the installation once the problem has been corrected.

Installationrollback and recovery make the installation and configuration of OracleClusterware and Oracle RAC easier. It reduces project time lines by making iteasy to recover from installation failures.

（20）Downgrading DatabaseConfigured With DBControl

Scripts areincluded to support DBControl downgrade as part of database downgrade.

If an upgrade isdeemed unsuccessful, the system needs to be returned to the starting release.In order to maintain the reliability of management when modifying softwarereleases, DBControl must be at the same release as the database that it ismonitoring.

（21）OracleRestart Integration with Oracle Universal Installer

（22）Out-of-PlaceOracle Clusterware Upgrade

（23）OUISupport for Out-of-Place Oracle Clusterware Upgrade

You can nowperform out-of-place upgrade of Oracle Clusterware software. The new versioncan be installed in a separate directory and pointed to during deployment.

Out-of-place upgrades provide easier OracleRAC and grid deployment and manageability, as well as better testing forcontrolled application migration.

（24）ServerControl (SRVCTL) Enhancements

（25）ServerControl (SRVCTL) Enhancements to Support Grid Plug and Play

（26）SRVCTLSupport for Single-Instance Database in a Cluster

（27）UniversalConnection Pool (UCP) Integration with Oracle Data Guard

（28）UCPIntegration With Oracle Real Application Clusters

（29）UniversalConnection Pool (UCP) for JDBC

（30）JavaAPI for Oracle RAC FAN High Availability Events

1.5Database Overall

The followingsections describe new database features for Oracle Database 11gRelease 2(11.2).

1.5.1General

The followingsections provide new feature information for Flashback Data Archive andinstance caging.

（1）Flashback Data Archive Support for DDLs

Oracle Database11gRelease 2 (11.2) users can now use most DDL commands on tables thatare being tracked with Flashback Data Archive. This includes:

1)Add, Drop, Rename, ModifyColumn

2)Drop, Truncate Partition

3)Rename, Truncate Table

4)Add, Drop, Rename, ModifyConstraint

For more complexDDL (for example, upgrades and split table), the Disassociate and AssociatePL/SQL procedures can be used to temporarily disable Total Recall on specifiedtables. The Associate procedure enforces schema integrity after association;the base table and history table schemas must be the same.

This featuremakes it much easier to use the Total Recall option with complex applicationsthat require the ability to modify the schema.

（2）Instance Caging

Instance Cagingallows the DBA to limit the CPU usage of an Oracle instance by settingtheCPU_COUNTinitialization parameter and enabling CPU resourcemanagement.

With InstanceCaging, users can partition CPU resources among multiple instances running on aserver to ensure predictable performance.

1.5.2Improvementsto Oracle Scheduler

The following sections detail improvementsmade to Oracle Scheduler.

（1）E-mail Notification

Oracle Database11gRelease 2 (11.2) users can now get e-mail notifications on any jobactivity.

This featureimproves efficiency by enabling users to be notified of any job activity thatis of interest to them without having to constantly monitor the job.

（2）FileWatcher

File watcherenables jobs to be triggered when a file arrives on a given machine.

This feature improves efficiency andease-of-use. Jobs with file dependencies are automatically triggered when thespecified file is received instead of constantly monitoring for the file.

（3）MultipleDestination Jobs

This featureenables users to specify multiple destinations for a job.

This is a keyfeature for Enterprise Manager scheduling. It improves efficiency andease-of-use by enabling a job to be run on multiple nodes while managing it asone entity from a central location.

（4）RemoteDatabase Jobs

This featureenables users to run PL/SQL blocks or stored procedures that reside in a remotedatabase as a job.

This is a keyfeature for Enterprise Manager scheduling. It improves efficiency andease-of-use by enabling job scheduling in a distributed environment to bemanaged centrally.

1.5.3Improvements to Utilities

The following features provide improvementsto the various utilities in Oracle Database 11gRelease 2 (11.2).

（1）Data Pump Legacy Mode

Data Pump LegacyMode provides backward compatibility for scripts and parameter files used fororiginal Export and Import scripts.

This featureenables users to continue using original Export and Import scripts with DataPump Export and Import. Development time is reduced as new scripts do not haveto be created.

1.5.4IPv6 Support

The following sections describeimprovements in IPv6 networking support.

（1）CompleteIPv6 Support for JDBC Thin Clients

（2）CompleteIPv6 Support for JVM and Java Debuggers

1.6Diagnosability

The followingsections describe diagnosability features for Oracle Database 11gRelease2 (11.2).

1.6.1Support Workbench

EnterpriseManager Support Workbench is a GUI workbench for customers and support to easediagnosis and resolution of database errors.

（1） Enterprise Manager Support Workbench for ASM

1.7Information Integration

The followingsections describe new information integration features for Oracle Database11gRelease 2 (11.2).

1.7.1OracleDatabase XStream

The following section describes the newOracle Database XStream feature.

（1） XStream

1.8Performance

The followingsections describe improvements in performance of the database and functionalityof performance-related database features.

1.8.1GeneralServer Performance

The following sections describe generalserver performance enhancements.

（1）DatabaseSmart Flash Cache

New in Oracle Database 11gRelease 2(11.2), the Database Smart Flash Cache feature is a transparent extension ofthe database buffer cache using solid state device (SSD) technology. The SSDacts as a Level 2 cache to the (Level 1) SGA.

Database Smart Flash Cache can greatlyimprove the performance of Oracle databases by reducing the amount of disk I/Oat a much lower cost than adding an equivalent amount of RAM.

（2）StoredOutlines Migration to SQL Plan Management

Stored outlinescan be migrated for future and enhanced usage with SQL Plan Management (SPM).

Stored outlineslack the flexibility and adaptability of SQL Plan Management. By providing amigration path, old applications using stored outlines can be transparentlymigrated and can instantaneously take advantage of the enhanced functionalityof SPM.

（3）ClientResult Cache Using Table Annotations Support

Tableannotations support provides the ability to annotate a table as being cacheworthy, which enables applications to leverage client and server result cachingthrough deployment time knobs as opposed to making application changes. Inaddition, this feature provides automatic client cache invalidation.

This featureallows non-intrusive application performance acceleration using client andserver result caches.

（4）Support4 KB Sector Disk Drives

Today, diskdrives have 512 byte sectors. Disk drive manufacturers are moving to 4 KBsector drives because it allows them to offer higher capacity with loweroverhead. If customers use 4 KB sector drives as 512 byte sector drives, thenthere is likely to be a performance penalty (because they have to run in 512byte emulation mode). This feature allows Oracle to work with 4 KB (and 512byte) sector drives without a performance penalty. There is also the capabilityin Automatic Storage Management (ASM) to allow migration of a disk group from512 byte sector drives to 4 KB sector drives.

This featureallows customers to take full advantage of new generation, higher capacity diskdrives.

1.9Security

The new featuresdiscussed in the following section cover areas that include encryption andauditing. Significant new encryption key management functionality has beenintroduced in Oracle Database 11gRelease 2 to enable complete integrationwith Hardware Security Modules and increased performance for Transparent DataEncryption. Audit Management has been simplified through the introduction of anew package for managing audit data on the Oracle database.

1.9.1Audit Data Management

Simplify themanagement of audit data created by the Oracle Database to facilitatecompliance with various privacy and compliance mandates such as SOX, HIPAA, andPCI.

（1） Audit Trail Cleanup

1.9.2EncryptionKey Management

Encryption keymanagement provides the ability to change the master key associated withtransparent data encryption (TDE) encrypted tablespaces. The tablespace masterkey is used to encrypt the encryption keys associated with individualtablespaces. This is commonly referred to as a 2-tier key architecture. Priorto Oracle Database 11gRelease 2 (11.2), changing the master key was onlypossible when using TDE column encryption.

（1） Tablespace Master Key Rekey

1.10Server Manageability

The followingsections describe server manageability features for Oracle Database11gRelease 2 (11.2).

1.10.1AutomaticStorage Management for All Data

These featuresextend the capabilities of Automatic Storage Management (ASM) to support alltypes of data including database files, clusterware files, and file system datasuch as Oracle homes and binaries.

The following sections describe ASMfeatures.

（1）ASM Cluster FileSystem (ACFS)

（2）ASM DynamicVolume Manager (DVM)

（3）ASM FSSnapshot

（4）OracleCluster Registry (OCR) and Voting Disk on ASM

（5）ASMIntelligent Data Placement

（6）ASMStorage Management Configuration Assistant

（7）AutomaticStorage Management (ASM) File Access Control

（8）ASMCMDCommand Extensions

（9）EnterpriseManager Support for ASM Cluster File System (ACFS)

（10）EnterpriseManager Integration for ASM File Access Control

1.10.2Database Management

The following sections describe general databasemanagement features to ease database management.

（1）EMCASupports New Oracle RAC Configuration for Enterprise Manager

（2）PatchApplication with DBControl

（3）AutomaticPatching of Time Stamp With Time Zone Data

（4）PreventData Loss for Time Zone with Local Time Zone Data Type

（5）SegmentCreation on Demand

（6）Zero-SizeUnusable Indexes and Index Partitions

（7）MetadataSXML Comparison Tool

（8）ComparePeriod Report

（9）CompareSQL Tuning Sets

（10）EnableSampling for Active Data Guard

（11）ExadataSimulation

（12）GlobalOracle RAC ASH Report + ADDM Backwards Compatibility

（13）OracleMTS and Streams Support

（14）ParallelQuery + Alt Plan Recording, Export STS Enhancements

（15）SynchronizationControls

1.11Unstructured DataManagement

The new featuresin the following sections describe the significant performance, developerproductivity and advanced capabilities in Oracle Multimedia, Oracle Spatial,Oracle Database SecureFiles, and XML Database.

1.11.1Enhanced Oracle Multimedia and DICOM Support

The following sections describe the newfeatures and capabilities for Oracle Multimedia and Digital Imaging andCommunications in Medicine (DICOM).

（1）AttributeExtraction of Requested Attributes Only

（2）Client-SideDICOM Attribute Extraction

（3）DICOMEnhancements

（4）Watermarkingand Image Processing Enhancements

1.11.2EnhancedOracle Spatial Support

The followingsections describe new features in Oracle Spatial support for 3D, geocoder,routing engine, GeoRaster, and network data model.

（1）3DVisualization Framework

（2）Network DataModel Enhancements

（3）NewGeoRaster JAVA API

（4）RasterReprojections and Ground Control Point-Based (GCP) Georeferencing

（5）Routingand Geocoding Enhancements

1.11.3OracleSecureFiles

The following sections describeimprovements in Oracle SecureFiles.

（1）DatabaseFile System (DBFS)

（2）Supportfor Oracle SecureFiles

1.11.4OracleXML DB Scale and Performance Improvements

The followingsections address key customer requirements in the area of scalability and performanceby delivering partitioning of XML tables, scaling on registering large XMLSchemata, significant improvements in XML indexing and query performance forcommon real-world workloads, and significant improvements in performance ofrepository operations.

（1）BinaryXML Enhancements

（2）OracleXML DB Repository Performance Improvements and Guidelines

（3）XMLIndexEnhancements

（4）XMLTypePartitioning

二. 11.2.0.2新特性

This chaptercontains descriptions of all of the features that are new to Oracle Database11gRelease 2 (11.2.0.2). This chapter contains the following sections:

(1)General

(2)ACFSImprovements

(3)Qualityof Service (QoS) Management

(4)DatabaseReplay

(5)Management

2.1General

The followingsections describe the new features for Oracle Database 11gRelease 2(11.2.0.2).

2.1.1General

The following sections provide informationon new features for 11.2.0.2.

（1）Control File Updates Can Be Disabled DuringNOLOGGING Operations

ParameterDB_UNRECOVERABLE_SCN_TRACKING= [ TRUE | FALSE ]can be used to turn off control file writes to updatefields that track the highest unrecoverable SCN and Time duringaNOLOGGINGdirect path operation.

Performance oftheNOLOGGINGload operation could be limited by the control filewrite I/O.

--DB_UNRECOVERABLE_SCN_TRACKING 参数可以在NOLOGGING下控制对控制文件的更新。

（2）NewPackage for Configuring Automatic SQL Tuning

A new PL/SQLpackage,DBMS_AUTO_SQLTUNE, has been introduced to provide morerestrictive access to the Automatic SQL Tuning feature.

--引入了新的包：DBMS_AUTO_SQLTUNE。

With thispackage, access to Automatic SQL Tuning can be restricted to DBAs so that onlythey can change its configuration settings that effect run-time behavior of thequery optimizer, such as enabling or disabling automatic SQL profile creation.

（3）EnhancedSecurity for DBMS_SCHEDULER E-Mail Notification

（4）EnhancedTRUNCATE Functionality

（5）Supportfor In-Place Upgrade of Clients

（6）MaintenancePackage for Segment Creation on Demand

（7）MaximumCPU Utilization Limit

Resource Managerprovides a new directive calledMAX_UTILIZATION_LIMITthat allows youto place a hard limit on the amount of CPU utilized by a consumer group.

TheMAX_UTILIZATION_LIMITdirectiveis useful for limiting the CPU utilization of low priority workloads. Thisdirective is also useful for providing more consistent performance for theworkload in a consumer group, and it helps to build systems where end usersexperience consistent response times for each database operation.

有关Resource manager 参考：

OracleResource Manager 概述

http://blog.csdn.net/tianlesoftware/article/details/7214155

（8）Name Matching

（9）NamedEntity Extraction

（10）Default Size of First Extent of Any NewSegment for a Partitioned Table Has Changed

The default sizeof the first extent of any new segment for a partitioned table is now 8 MBinstead of 64 K.

--分区表的任何新的segment 默认的第一个extent 大小从64k变成8M。

The goal is toimprove I/O performance. However, under certain circumstances, loading a tablewill take significantly more disk space.

（11）ParallelStatement Queuing

（12）PMMLImport

（13）ResultSet Interface

（14）SegmentCreation On Demand for Partitioned Tables

（15）Simplificationof XML and XQuery Interfaces

（16）SMTPAuthentication

（17）SMTPEncryption

（18）SPASupport for Active Data Guard Environment

（19）The EDITIONAttribute of a Database Service

（20）UsingBinary XML with SecureFiles as the XMLType Default Storage

（21）JDBC4.0 SQLXML

（22）ID KeyLCRs in XStream

2.1.2ACFS Improvements

The following sections provide informationon ACFS improvements for 11.2.0.2.

（1）ACFS,ADVM and Snapshots on Solaris and AIX

（2）OracleACFS Replication

（3）OracleACFS Security and Encryption Features

（4）OracleACFS Tagging

2.1.3Qualityof Service (QoS) Management

A new Quality ofService (QoS) Management Server enables run time management of service levelsfor hosted database applications on a shared infrastructure by clusteradministrators. The goal is to present an easy-to-use, policy-driven managementsystem that ensures meeting service levels if sufficient resources areavailable and when they are not, allocates resources to the most business criticalworkloads not meeting their service levels at the expense of the less criticalones.

The following sections describe Quality ofService Management Server features.

（1）DatabaseQoS Management Server

（2）DatabaseQuality of Service (QoS) Management Support

（3）EnterpriseManager QoS Management Integration

（4）ServerMemory Stress Protection for Oracle Clusters

2.1.4Database Replay

The followingsections provide information on new Database Replay features for 11.2.0.2.

（1）DatabaseReplay SQL Performance Analyzer (SPA) Integration

（2）DatabaseReplay Timeout Function

（3）DatabaseReplay Workload Analyzer

2.1.5Management

The following sections provide informationon new management features for 11.2.0.2.

（1）DBCASupport for Creating an Oracle RAC One Node Database

（2）Optionof Downloading Latest Updates During Installation

（3）OracleASM Configuration Assistant Support for Out-of-Place Upgrades

（4）OracleDatabase Upgrade Assistant Support for Out-of-Place Upgrades

（5）OracleEnterprise Manager DB Control Support for Oracle RAC One Node

（6）OnlineRelocation of an Oracle RAC One Node Database

（7）SRVCTL-BasedManagement of Oracle RAC One Node Databases

（8）CRSCTLCommand Enhancements

（9）SRVCTLCommand Enhancements

（10）EnhancedXStream Manageability

（11）ColumnarCompression Support in Supplemental Logging and XStream

（12）StandaloneConfiguration Wizard for Post-Installation Cluster Configuration

（13）RedundantInterconnect Usage

三. 11.2.0.3 新特性

This chaptercontains descriptions of all of the features that are new to Oracle Database11gRelease 2 (11.2.0.3).

3.1General

The following sections describe the newfeatures for Oracle Database 11gRelease 2 (11.2.0.3).

3.1.1SupportHybrid Columnar Compression on Pillar Axiom and Sun ZFSSA

3.1.2Support forSHA-2 Certificate Signatures

3.1.3TDEHardware Acceleration for Solaris

3.1.4Support forMultiple Certificates on Smart Card

3.1.5QoSManagement Support for Oracle RAC Enterprise Edition

3.1.6QoSManagement Support for Instance Caging on Exadata

3.1.7Oracle ACFSSnapshot Enhancements

3.1.8OracleACFS Security and Encryption Features

3.1.9Supportfor ACFS Replication and Tagging on Windows

3.1.10OracleLogMiner Support for Binary XML

3.1.11SQLApply Support for Binary XML

3.1.12OracleLogMiner Support for Object Relational Model

3.1.13SQLApply Support for Object Relational Model

3.1.14Deprecationof Obsolete Oracle XML DB Functions and Packages

3.1.15OracleWarehouse Builder Support for Partition DML

3.1.16EnhancedPartitioning Support in Oracle Warehouse Builder

3.1.17OracleWarehouse Builder External Table Data Pump Support

3.1.18OracleWarehouse Builder External Table Preprocessor Support

3.1.19CompressedTable and Partition Support in Oracle Warehouse Builder

3.1.20Supportfor PL/SQL Native Compilation

-------------------------------------------------------------------------------------------------------

版权所有，文章允许转载，但必须以链接方式注明源地址，否则追究法律责任!

Email: [e-mail]

Skype: tianlesoftware

Blog: http://www.tianlesoftware.com

Weibo: http://weibo.com/tianlesoftware

Twitter: http://twitter.com/tianlesoftware

Facebook:http://www.facebook.com/tianlesoftware

-------加群需要在备注说明Oracle表空间和数据文件的关系，否则拒绝申请----

DBA1 群：62697716(满); DBA2 群：62697977(满)DBA3 群：62697850(满)

DBA 超级群：63306533(满); DBA4 群：83829929 DBA5群： 142216823

DBA6 群：158654907 DBA7 群：172855474 DBA总群：104207940