SAP Basis Tech Supports

Symptom

New functions in Oracle Database 10g

This note provides information about new Oracle database features and Oracle database features supported in the SAP environment as of Oracle database 10g.
Features that are not (yet) supported in the SAP environment are listed in Note 105047.
Other terms

Oracle Database 10g Release 1 (10.1), 10.1.0
Oracle Database 10g Release 2 (10.2), 10.2.0
Reason and Prerequisites

You use Oracle Release 10g for your SAP system.
Solution

Oracle features in the SAP standard system

As of Oracle Release 9.2, the following features are part of the SAP standard for new SAP installations with Oracle:
Server Parameter File (SPFILE):Automatic Undo Management/AUMDefault Temporary TablespaceDynamic SGAAutomatic PGALocally-managed Temporary Tablespace
(as of SAP WebAS 6.xx or SAP NetWeaver 2004)
These Oracle features (see Note 598678) should all be active.
Locally managed tablespaces/ASSM tablespaces
LMTS tablespaces and ASSM tablespaces (see Notes 620803, 214995) are also part of the standard for SAP installations as of Oracle Release 9.2.
When you extend a database with new tablespaces or if you restructure a database, we recommend to create the new tablespaces as LMTS and ASSM tablespaces.
Support for Oracle Database 10g by BR*Tools

As far as the administration of the Oracle database is concerned, the new features of Oracle Database 10g are generally supported byBR*Tools 7.00and higher. For more information, see Note 849483 for BR*Tools Version 7.00.
New Oracle Database 10g features in the SAP environment

Oracle database administration (manageability features)
Tablespace SYSAUX
See Note 872851.Oracle Enterprise Manager 10g Grid Control/Database Control
Allowed for monitoring purposes.
Support directly from Oracle (no SAP support).
See Note 105047.LONG-LOB migration of tables
See Note 835552.Online shrinking of segments (”Online Segment Shrink”)
See Note 910389.Default Permanent Tablespace
See Note 969674.Database-internal maintenance jobs
See Notes 974781 and 927813.Database copy using transportable tablespaces (as of 10.2)
See Note 1003028 (BR*Tools).Statistics about the usage of Oracle features (DBA_FEATURE_USAGE_STATISTICS)
See Note 105047.Statistics about the usage of Oracle resources
(DBA_HIGH_WATER_MARK_STATISTICS)
See Note 592393: FAQ: OracleAutomatic undo retention
See Note 1035137.Index key compression
See Note 1109743.Automatic Shared Memory Management (ASMM, parameter SGA_TARGET)
See Note 105047.
Oracle software logistics (patches, patch sets and so on)
Instant Client
See Note 819829.Oracle Universal Installer 10g
See Notes 833766 and 980426.OPatch 10.1/10.2
See Note 839182.Required patches and patch sets
Release 10.2.0.2: See Note 871096.
Release 10.2.0.4: See Note 1137346.Patch installation with MOPatch
See Note 1027012.OPatch function to clean up the patch storage directory
See Note 1026237 (’opatch util cleanup’).
Oracle database performance features
New Oracle statistics for the Oracle Cost Based Optimizer: System statistics and Oracle Dictionary statistics
See Note 838725.New self-tuning and self-analysis tool: ADDM
See Note 853576.
As of 10g, you should no longer use the Statspack PL/SQL package (see Note 717484), which is recognized by Oracle 9i. Instead, Oracle Database 10g provides the ‘Automatic Workload Repository’ (AWR) that is integrated into the database and the ‘Automatic Database Diagnostic Monitor’ (ADDM).
Oracle database security
New database role SAPCONN
See Note 834917.Network encryption
See Note 973450.Transparent data encryption (TDE)
See Notes 974876 and 1279682.RMAN back-up encryption
See Note 1324684.Database auditing
This is planned for a later time.Oracle Database Vault (DV)
In pilot phase (see Note 105047).
Oracle backup and recovery features
Block Change Tracking (as of Release 10.2.2)
See Note 964619.Flash Recovery Area
See Note 966073.Flashback Database
See Notes 966117 and 1125923.
Oracle database upgrade
Database upgrade with OFFLINE tablespaces
See Note 997711.New Dictionary table DBA_REGISTRY_HISTORY
Contains a history of database upgrades.
See Note 1017936.