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.
Oracle Advanced Performance Tuning for SAP ERP (Level II)
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.
Index design and the usage of index compression
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
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.
Block dumps of the different segments (tables, indexes, rollback segments)
Data storage (incl. Long/LOB)
Using events for error analysis and debugging
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
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.
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.