Looking to expand your SAP knowledge using trusted resources? Our SAP NetWeaver AS - DB Operation (Oracle) (TADM51), latest book from SAP Learning Hub, is your key to mastering SAP systems and processes. Perfect for students, professionals, and SAP enthusiasts, this book provides verified content straight from the source.
Unit 1: Database Overview
Lesson: Reviewing Database Architecture
Lesson: Connecting to the Database
Lesson: Using Database Administration Tools
Lesson: Administrating Oracle Instances
Unit 2: Backup, Restore, and Recovery
Lesson: Reviewing a Backup Strategy
Lesson: Reviewing Backup Tools
Lesson: Performing Backups
Lesson: Performing Restore and Recovery
Lesson: Working with Advanced Backup Techniques
Unit 3: Monitors and Tools
Lesson: Introducing Oracle Data Management
Lesson: Managing Database System Check
Lesson: Explaining Computing Center Management System (CCMS) Alert Monitor
Unit 4: Space Management
Lesson: Administering Tablespaces
Lesson: Performing Reorganization of Tables
Lesson: Housekeeping and Troubleshooting
Unit 5: Oracle Cache Management
Lesson: Introducing Oracle System Global Area
Lesson: Introducing Automatic Oracle Program Global Area
Unit 6: Monitoring of the Database Instance
Lesson: Working in the DBA Cockpit Performance Monitor
Lesson: Using the DBA Cockpit to Monitor the Database
Unit 7: Application Design Analysis
Lesson: Understanding the Impact of Expensive SQL Statements
Lesson: Using SM50/SM66 to Find Expensive SQL Statements
Lesson: Using ST03N/STAD to Find Expensive SQL Statements
Lesson: Using DBA Cockpit to Find Expensive SQL Statements
Lesson: Using SQL Trace to Find Expensive SQL Statements
Lesson: Monitoring Exclusive Lock Waits
Unit 8: Index Management and Optimization
Lesson: Utilizing Indexes
Lesson: Creating an Index
Unit 9: Cost-Based Optimizer
Lesson: Updating Statistics
Lesson: Detecting Problems with Optimizer Statistics
Unit 10: Analysis of Physical and Logical Layout
Lesson: Defragmenting Indexes
Lesson: Working with I/O Contention
Unit 11: Memory Configuration Analysis
Lesson: Describing Data Buffer Utilization
Lesson: Analyzing the Efficiency of Shared Pool
Lesson: Monitoring the Automatic Program Global Area