Oracle Database for SAP Technical Skills Workshops

As an outcome of the Oracle and SAP partnership, Oracle Advanced Customer Services offers specialized workshops for SAP customers. Practical training is the focus and format of these workshops. The workshops are generally held on the customer's site and use the customer's training systems, if possible. Practitioner-oriented handouts and materials are part of every workshop.

>>Data Sheet: Database Services for SAP Environments – Technical Skills Workshops

TECHNICAL SKILLS WORKSHOPS

 
Oracle Fundamentals for SAP ERP (Level I)
Goals This workshop is the foundation for building the basic knowledge for the successful use of an Oracle Database in an SAP environment.
Topics
  • Basic functions of the database
  • Tablespace layout
  • SAP's table concept
  • Fundamentals of the Oracle optimizer
  • Fundamentals of performance
  • Backup/ restore / recovery fundamentals
  • SAP work processes
  • SQL*Net fundamentals
Duration 5 days
Prerequisites None. This workshop is for customers who are new to supporting Oracle Databases within an SAP application environment.
Contact Contact your local service delivery manager.
 
Oracle Advanced Performance Tuning for SAP ERP (Level II)
Goals The Oracle Advanced Workshop builds on Oracle Fundamentals for SAP ERP and focuses on individual topics which play a deciding role in Oracle Database administration and performance in an SAP application environment.
Topics
  • DBWR architecture
  • Index design and the usage of index compression
  • Parallel processing
  • Partition setup with SAP
  • Security – base concepts
  • Statement analysis and solving SQL problems with SAP transactions (ST04/ST05)
  • Oracle Cost Based Optimizer – parameters, detailed information related to cost calculations, known issues
  • Detailed analysis of performance problems
  • Specific recovery situations
Duration 5 days
Prerequisites Oracle Fundamentals for SAP ERP (see above)
Contact Contact your local service delivery manager.
 
Oracle for Expert for SAP ERP (Level III)
Goals This workshop is designed for DBAs who want to discover in detail how the Oracle Database works in the SAP environment. In times of increasing demands on system administrators, this course can help DBAs to carry out most problem analysis independently.
Topics
  • Block dumps of the different segments (tables, indexes, rollback segments)
  • Data storage (incl. Long/LOB)
  • Using events for error analysis and debugging
  • ORA-600 analysis
  • System and process state dumps
  • Lock situations and how to react
  • Oracle latches—what they are and how to analyze problems with latches
  • Cost Based Optimizer—optimizer trace, join cost calculations
Duration 3 days
Prerequisites Fundamentals of Oracle for SAP ERP Technical Skills Workshop (Level I) and Oracle Advanced Performance Tuning for SAP ERP Technical Skills Workshop (Level II). See above for more information.
Contact Contact your local service delivery manager.
 
Oracle Database 11g for SAP Business Suite
Goals This workshop provides an overview of Oracle Database 11g and how to leverage new features and increased capabilities in an SAP application environment.
Topics
  • New background processes
  • Automatic Memory Management
  • Tablespace encryption
  • Deferred segment creation
  • Partition enhancements
  • Advanced compression
    • Table compression
    • SecureFiles compression
    • Data Pump compression
    • RMAN compression
  • SecureFiles—the successor for LOB/LONG RAW column types
  • Statistic generation with 11g and SAP
  • SAP Oracle parameter recommendations
  • Oracle Database 11g cost-based optimizer with
    • General enhancements
    • Adaptive cursor sharing (bind peeking)
    • SQL plan management
  • Diagnostic repository
  • Database replay
  • Online monitoring of expensive SQL statements
  • SQL tuning enhancements
  • Changes/improvements to the Oracle wait interface
Duration 4 days
Prerequisites Oracle Fundamentals for SAP ERP (see above)
Contact Contact your local service delivery manager.
 
Oracle Database Administration for SAP NetWeaver Business Warehouse (BW)
Goals This workshop provides an overview of the differences in how Oracle Databases interact with SAP BW and standard SAP applications.
Topics
  • SAP BW base concepts (cubes, star schema)
  • Partitioning strategy for SAP BW
  • SAP BW Indexing Design/Approach
  • Cost Based Optimization in SAP BW
  • Table design (e.g. ODS/DSO, F/E/D tables)
  • Analyze/Tuning complex BW queries
  • Optimization of BW change runs
  • Optimization of BW aggregate runs
  • Database parameters for SAP BW
Duration 3 days
Prerequisites Oracle Fundamentals for SAP ERP (see above); basic SAP BW knowledge
Contact Contact your local service delivery manager.
 
Oracle Real Application Clusters for SAP Applications
Goals This workshop provides an overview of how to maximize performance and leverage the features and capabilities of RAC in an SAP application environment.
Topics
  • Cluster Ready Service (CRS) and RAC Architecture
  • Installation and configuration
  • Cache Fusion
  • Administration of an Oracle/SAP/RAC environment
  • Network configuration/optimization
  • SAPCTL
  • Performance monitoring of a RAC cluster
  • Backup considerations with RAC
  • Transparent Application Failover
  • Database parameters for SAP-RAC
  • Oracle cluster manager/Cluster Ready Services (CRS)
  • Oracle Cluster File System (OCFS)
  • Error analysis in RAC environments
  • SAP enqueue/replication server
  • Command line tools
Duration 5 days
Prerequisites Oracle Fundamentals for SAP ERP (see above)
Contact Contact your local service delivery manager.
 
Oracle Security for SAP ERP Customers
Goals Due to compliance requirements, both external (such as Sarbanes-Oxley (SOX) Act, etc.) and internal, security is a focus of SAP customers. The focus of this workshop is to explore the features of the Oracle Database that are important for SAP customers to safeguard their systems on the Oracle Database level.
Topics
  • Database user security
    • Passwords
    • Roles and privileges
    • Profiles
  • Auditing
    • Mandatory auditing
    • Standard auditing
    • Fine-grained auditing
  • Database links
  • Network security
    • Listener security
    • Network encryption
  • Transparent Data Encryption
    • Installation and setup of column encryption
    • Encrypted RMAN save sets
    • Export and import
  • Oracle Database Vault
    • Definitions
      • Separation of duties
      • Installation and configuration
    • CPU patches
Duration 3 days
Prerequisites Oracle Fundamentals for SAP ERP (see above)
Contact Contact your local service delivery manager.
 
SAP ERP ABAP Tuning With Oracle Database Platform
Goals This workshop provides instruction on how to analyze and tune ABAP programs relative to Oracle Database features and functions.
Topics
  • Overview of Oracle Architecture
  • Data access methods
  • Index design for SAP
  • Use of database hints in ABAP
  • Using application transactions for query tuning
  • Understanding RBO and CBO
  • Common ABAP programming errors
Duration 2 days
Prerequisites None
Contact Contact your local service delivery manager.