Docstoc

Oracle_Architecture-Oracle_Database_and_Real_Application_Clusters_for_SAP_Applications

Document Sample
Oracle_Architecture-Oracle_Database_and_Real_Application_Clusters_for_SAP_Applications Powered By Docstoc
					     <Insert Picture Here>




Oracle Database and Real Application Clusters for
SAP Applications
Christoph Kersten
Oracle/SAP Global Technology Center (Walldorf, Germany)
  Oracle/SAP: Technology Integration

 2006
  Q2        Oracle Database 10g Release 2
  Q2        Oracle Partitioning for SAP ERP
  Q3        ODM Connector for SAP BW 2.1
  Q3        Content Database Archive Adapter (CDAA)
  Q4        Oracle RAC 10g (OCFS, Clusterware, SAPCTL)
 2007
  Q1        Oracle 11g Beta Program
  Q2        MOPatch
  Q3        Advanced Security Option (Network & Data Encryption)
  Q4        Flashback Database



SAPPHIRE 08 / OR4143
  Oracle/SAP: Technology Integration

 2008
  Q1        Index Key Compression
  Q3        Oracle Database Vault
  Q4        More automation for Partitioning (ERP)
 2009
  Q2        Oracle 11g Release 2




SAPPHIRE 08 / OR4143
  Standard Oracle Architecture




               Instance   Database




SAPPHIRE 08 / OR4143
  RAC: Architecture


                                             Database
         High Speed Interconnect


                                            Instance 1


                                                                   Table A
                                             Database
                                            Instance 2             Table B
                                                                   Table C

                                             Database    Disk Subsystem accessed
                                            Instance 3   via
                                                         • [Raw Devices]
                                                         • Cluster File System
                                   Cache
                                                         • Network-Attached Storage
                                   Fusion


SAPPHIRE 08 / OR4143
  RAC: Advantages

• High Availability
    • Minimal number of users interrupted
    • Minimal downtime
• Workload Distribution
    • No idle machines
• Scalability
    • Scale-out instead of scale-up
• Cost Reduction
    • High-end workload — low-end machines




SAPPHIRE 08 / OR4143
                     RAC: Scalability
                                                                                                                                    5 Node RAC
                     40,000
                                                                                                                                           37,040

                     35,000
                                                                                                               4 Node RAC
                                                                                                                   30,016
                     30,000
                                                                                      3 Node RAC
                     25,000
                                                                                            22,416
          SD Users




                     20,000                                      2 Node RAC
                                                                    15,520
                     15,000

                     10,000
                              Single Node SMP
                                   4,010
                      5,000
                              2,035

                         0
                               4      8 12 16 20 24 28 32 36 40 44 48 52 56 60 64 68 72 76 80
                                                                          # of CPU Cores
                                           Near Perfect Scaling across SMP and Cluster

These results, as of March 25, 2008, have been certified by SAP AG, www.sap.com/benchmark. Please see notes page for benchmark certification details for the above results.

              SAPPHIRE 08 / OR4143
   Partitioning: Support from SAP

   SAP NetWeaver Business
                                      SAP ERP (formerly SAP R/3)
Intelligence (formerly SAP BW)

 • All types of partitioning are   • All types of partitioning are
   supported                         supported
     • Range                          • Range
     • List                           • List
                                      • Hash
     • Hash
                                   • Partitioning not used by
 • Range partitioning used by        default
   default
                                   • Best candidates need to be
 • Same set of tables can be         selected for every system
   partitioned in all systems      • Oracle Support & Services for
 • Standard solution                 SAP offer
   (part of installation)          • See SAP Note 742243



 SAPPHIRE 08 / OR4143
                Partitioning: Customer Example (SAP ERP)


                           700

                           600
Batch Runtime in Minutes




                           500

                           400

                           300

                           200

                           100

                            0
                                 Query1   Query2   Query3   Query4   Query5   Query6




SAPPHIRE 08 / OR4143
  Efficient Data Storage: Overview

       Advanced Compression
           (Oracle 11g)           • Most efficient storage of data
                                     • Number values
     Partitioning + Compression      • Bitmap Index
             (Oracle 10g)         • Most comprehensive set of
                                    compression options
       Index Key Compression
             (Oracle 10g)         • Combination with other Data-
                                    base Options (Partitioning)
            Data Compression        increases advantages
               (Oracle 10g)       • Easy administration
                                    (e.g. reduction of
         Efficient Data Storage     reorganizations required)




SAPPHIRE 08 / OR4143
  Efficient Data Storage
  Internal Representation of Numerical Values


         INSERT INTO XYZ (COL1, COL2, COL3)
         VALUES (12, 1234, 123456);



       Fixed Length Representation:
                       V1        V2 V2   V3 V3 V3

       Variable Length Representation:
        L1 V1 L2 V2 V2 L3 V3 V3 V3




SAPPHIRE 08 / OR4143
  Data Compression
  Oracle Implementation

• One symbol table for every single block
• and located in that particular block


  Symbol
   Tables
                       xxxx x x   xxxxx   xxxx x x   xxxxx   xxxx x x   xxxxx
                       xxxx x x   xxxxx   xxxx x x   xxxxx   xxxx x x   xxxxx
                       xxxx x x   xxxxx   xxxx x x   xxxxx   xxxx x x   xxxxx
                       xxxx x x   xxxxx   xxxx x x   xxxxx   xxxx x x   xxxxx


                         Data Block         Data Block         Data Block




SAPPHIRE 08 / OR4143
  Index Compression
  Motivation


        SAP ERP: Example 1     SAP ERP: Example 2
                                   Index
         Index
                                   30.8%
         38.5%




                        Data                Data
                       61.5%               69.2%




SAPPHIRE 08 / OR4143
  Oracle Index Key Compression
Department1            Job1   <name>   D1J1     <name>
Department1            Job1   <name>   D1J1     <name>
Department1            Job1   <name>   D1J1     <name>
Department1            Job2   <name>   D1J2     <name>
Department1            Job2   <name>   D1J2     <name>
Department1            Job2   <name>   D1J2     <name>
Department2            Job1   <name>   D2J1     <name>
Department2            Job1   <name>   D2J1     <name>
Department2            Job1   <name>   D2J1     <name>


             Prefix           Suffix   Prefix   Suffix


SAPPHIRE 08 / OR4143
  Advanced Security Option (ASO)

     Application

                       Network Encryption
                        supported as of February 2008
                        see SAP Note 973450

     Database
      Server
     Instance

                       Transparent Data Encryption
     Database
       Files            supported as of February 2008
                        see SAP Note 974876



                       Backup Set Encryption
     Database
      Backup            using Oracle Recovery Manager (RMAN)
                        in preparation



SAPPHIRE 08 / OR4143
     Oracle Database Vault
     Realms, Factors, Rules


• Database DBA attempts                        alter system…….
  remote “alter system”
    Rule based on IP                  DBA
    Address blocks action
                                                 create …
• HR DBA performs                                                     HR
                                                                     HR
  unauthorized actions                HR DBA       3pm Monday    HR Realm
  during production
       Rule based on Date and
       Time blocks action

Factors and Command Rules provide flexible and adaptable security controls.


   SAPPHIRE 08 / OR4143
SAPPHIRE 08 / OR4143
  MOPatch

• Simplifies the task of installing Multiple Oracle
  Patches into an ORACLE_HOME
• Tool specific to SAP software
• Based on Oracle‘s OPatch utility
  (available with Oracle Database 10g)




SAPPHIRE 08 / OR4143
  For more information ...


                        ... see our newsletter
                       and visit

                       www.oracle.com/sap




SAPPHIRE 08 / OR4143
SAPPHIRE 08 / OR4143
Access SAPPHIRE ’08
Orlando Online
Watch video recordings, download audio files
in MP3 format, and view the slides from
all keynotes and presentation sessions.




www.sap.com/us/sapphire

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:4
posted:6/25/2012
language:English
pages:21