Key Features of Oracle Database for SAP Customers


Deploying Oracle Database 11g Release 2 within their IT architecture, SAP customers can reduce server and storage costs, eliminate idle redundancy, and improve quality of service. Learn how Oracle Database features and additional options provide distinct benefits to organizations deploying SAP.

Performance and Scalability     >>Learn More
Feature Benefits
Automatic Storage Management (ASM)
  • Distributes data evenly across disks to eliminate hot spots and provide uniform performance
  • Comparable to the performance of raw devices, but much easier to manage
Direct NFS Client
  • Improves throughput of NAS solutions such as NetApp, with up to 50% more database throughput in NAS environments with multiple NICs and up to 20% CPU savings on database servers
  • Works for single-instance and real application clusters (RAC)
  • Works for UNIX/Linux and Windows platforms
  • Faster, easier, and more available than any OS- or NAS- based bonding or trunking solution
Real Application Clusters (RAC)
  • Provides the scalability options at the database layer that you have always had on the SAP application layer
Table and Index Partitioning
  • Reduces I/O, memory usage, and CPU workload dramatically
Deployment Flexibility     >>Learn More
Feature Benefits
Automatic Storage Management (ASM)
  • Starting with Oracle Database 11g Rel. 2, Oracle ASM is the preferred storage platform for SAP systems running on Oracle RAC and single instance
  • ASM is an alternative to conventional volume managers, file systems, and raw devices
  • SAP on RAC customers do not need to use any third party shared cluster file system
  • SAP high availability (Enqueue Services) in RAC environments can be covered by Oracle Clusterware (SAPCTL)
Oracle Database
  • Offers the same features and tools on all hardware and OS platforms
  • Allows you to change platforms at any time
Real Application Clusters (RAC)
  • Gives you the choice between scale-up and scale-out strategies if your workload increases
Real Application Testing
  • Helps you test changes against real-life workloads, and then helps you fine-tune the changes before putting them into production
  • Database Replay enables you to rerun actual production workloads, including online user and batch workloads, in test environments
  • SQL Performance Analyzer (SPA) can predict and prevent SQL execution performance problems caused by environment changes
Virtualization Support
  • Provides support for hardware- and OS-specific virtualization technologies available or planned
  • Provides VMWare support for test and productive SAP environments
Availability and Reliability     >>Learn More
Feature Benefits
Data Guard
  • If primary database becomes unavailable, standby database can easily assume the primary role
  • Standby database can also be used for read-write, reporting, testing, or backups, reducing the load on the primary database
  • Completely transparent to SAP applications
  • In combination with Flashback Database, removes the need to delay application of logs and to reinstantiate primary after failover
  • Balances cost, availability, performance, and transaction protection with flexible data protection modes
  • Primary and standby databases can be Real Application Clusters or Oracle single-instance
Flashback Technology
  • Quickly rewinds an Oracle database to a previous point in time to correct issues caused by logical data corruptions or user error
Real Application Cluster (RAC)
  • Offers virtually uninterrupted processing for users and eliminates the need for manual recovery steps
  • Enables enterprise grids to deliver the highest quality of service that rivals and exceeds expensive mainframes
  • The SAP Control Utility provides an easy-to-use interface to administer the resources, scripts, and dependencies of Oracle Clusterware and SAP high-availability components
Support for Very Large Databases     >>Learn More
Feature Benefits
Data Guard Network Compression
  • Enables network compression when shipping log files
  • Largest benefit in bandwidth constrained environments
Data Pump Compression
  • Compresses metadata and table data on export
  • Reduces dump file size
  • No need to uncompress a dump file before importing it
Index Key Compression
  • Allows compression of B*Tree indexes (make up to one-third of disk space allocated to database in SAP environments)
  • Reduces I/O and improves overall performance
  • Tightly integrated with SAP BR*Tools
RMAN Backup Compression
  • Provides full or incremental backups
  • Uses a Block Change Tracking File (BCTF) to identify changes in blocks for an incremental backup
  • Reduces size of backup files as well as backup time
  • Prerequisite for compression of SAP tables containing LOBs (e.g. cluster tables)
SecureFiles Compression
  • Compresses unstructured data using industry-standard compression algorithms
  • Can compress data stored inline as well as out-of-line
Storage Efficiency
  • The Oracle Database needs up to 40% less disk space for the same data than other databases even without explicit compression
  • Provides variable length representation of number values
  • Persistent bitmap indexes provide significant space and performance advantages
  • Segment creation is deferred, saving significant disk space
  • Optimizes the resource usage and storage requirements for adding new columns with DEFAULT values and NOT NULL constraints
Table and Index Partitioning
  • Partitions containing historical data only can be compressed, reducing disk space
Table Data Compression
  • Efficient table data compression results in considerable disk space savings
  • No performance penalties—and in many cases throughput increases due to I/O reduction and better use of in-memory caches
  • Symbol tables are built for and stored in every single block, providing greater flexibility and manageability
  • No uncompress operation in memory required
  • Tightly integrated with SAP BR*Tools
Unicode Support
  • Efficient Unicode implementation leads to very limited database growth when migrating from non-Unicode to Unicode
  • Oracle-specific R3Load optimizations and enhancements make a Unicode migration dramatically faster
Security      >>Learn More
Feature Benefits
Oracle Advanced Security
  • Network Encryption protects data in transit between SAP Application Server and Oracle Database Server
  • Column-level or tablespace-level Data Encryption protects data in the database
  • Backup Set Encryption protects backup copies of database files
  • Tightly integrated with SAP BR*Tools
Oracle Database Vault for SAP
  • Restricts access by unauthorized database users—even privileged users—by using powerful access controls
  • Implements separation-of-duty and other real-time preventive controls
  • Prevents application bypass with multi-factor policies that are enforced in the database
  • Uses certified default policy for SAP applications
Manageability and Self-management     >>Learn More
Feature Benefits
Administration Interfaces from SAP
  • BR*Tools Studio is a powerful database administration (DBA) package for Oracle databases offered by SAP
  • SAP DBA Cockpit is a platform-independent tool that you can use to monitor and administer your Oracle database and Real Applications Clusters
Deferred Segment Creation
  • Allocates no disk space for empty database objects (60-70% of all tables, indexes, and partitions in average SAP environments)
  • Makes database installation for SAP much faster
  • Oracle Data Dictionary Space queries run substantially faster
Dictionary-only Add Column
  • Improves performance of Add Column ten to 20 times
  • Frequently used during SAP upgrades
Enterprise Manager: Diagnostics Pack
  • Manages the performance your Oracle Database environment cost-effectively
  • Includes Automatic Database Diagnostic Monitor (ADDM), a self-diagnostic engine built right into the Oracle Database kernel
  • Advanced Session History (ASH) samples the current state of all active sessions and stores it in memory
  • Advanced Workload Repository (AWR), the foundation for all self-management functionality, enables Oracle Database to make decisions and also facilitates historical performance analysis
Enterprise Manager: Provisioning Pack
  • Significantly reduces time and effort involved in manual patching activity
Patching Technologies and Tools
  • MOPatch automates installation of multiple Oracle patches
  • Online Patching allows you to install single or bundle patches completely offline without shutting down the database instance
Real Application Testing
  • Helps you test changes against real-life workloads, and then helps you fine-tune the changes before putting them into production
  • Database Replay enables you to rerun actual production workloads, including online user and batch workloads, in test environments
  • SQL Performance Analyzer (SPA) can predict and prevent SQL execution performance problems caused by environment changes
Snapshot Standby Database
  • Allows easy conversion of a physical standby database to a reporting database
Table and Index Partitioning
  • Partitions can be managed individually and independently
Reduced Cost of Ownership     >>Learn More
Feature Benefits
Real Application Clusters (RAC)
  • Using RAC, even high-end systems can be deployed on commodity servers
  • Oracle Clusterware eliminates the need to purchase proprietary, expensive third-party clusterware in order to have a RAC database
Automatic Storage Management (ASM)
  • Reduces cost and complexity (e.g. no third-party cluster file system, no raw devices required) without compromising performance or availability
Oracle Compression Technologies
  • The combination of all Oracle compression technologies can save 50-70% of disk space allocated to database
  • Less I/O and better use of memory result in more throughput using the same hardware

Oracle for SAP Newsletter Banner