TADM 51
- Home
- TADM 51
TADM 51(SAP NETWEAVER AS-DB OPERATION (ORACLE)
DATABASE OVERVIEW
- Reviewing Database Architecture
- Connecting to the Database
- Using Database Administration Tools
- Administrating Oracle Instances
MONITORS AND TOOLS
- Introducing Oracle Data Management
- Managing Database System Check
- Explaining CCMS Alert Monitor
ORACLE CACHE MANAGEMENT
- Introducing Oracle System Global Area
- Introducing Automatic Oracle Program Global Area (PGA)
APPLICATION DESIGN ANALYSIS
- Understanding the Impact of Expensive SQL Statements
- Using SM50/SM66 to Find Expensive SQL Statements
- Using ST03/STAD to Find Expensive SQL Statements
- Using ST04 to Find Expensive SQL Statements
- Using SQL Trace to Find Expensive SQL Statements
- Monitoring Exclusive Lock Waits
COST-BASED OPTIMIZER
- Updating Statistics
- Detecting problems with Optimizer statistics
MEMORY CONFIGURATION ANALYSIS
- Describing Data Buffer Utilization
- Analyzing Efficiency of Shared Pool
- Monitoring the Automatic Program Global Area (PGA)
BACKUP, RESTORE AND RECOVERY
- Reviewing a Backup Strategy
- Reviewing Backup Tools
- Performing Backups
- Performing Restore and Recovery
- Working with Advanced Backup Techniques
SPACE MANAGEMENT
- Administrating “Table Spaces”
- Performing Reorganization of Tables
- Housekeeping and Troubleshooting
MONITORING OF THE DATABASE INSTANCE
- Using the DBA Cockpit to Monitor the Database
- Understanding the DBA Cockpit support of Oracle database features
INDEX MANAGEMENT AND OPTIMIZATION
- Utilizing Indexes
- Creating an Index
ANALYSIS OF PHYSICAL AND LOGICAL LAYOUT
- Defragmenting Indexes
- Working with I/O Contention