• An empty cart

    You have no item in your shopping cart

Enter your keyword



sap career

About Instructor

Solution Release NW AS ABAP 7,40

Database Overview

  • Reviewing Database Architecture
  • Connecting to the Database
  • Using Database Administration Tools
  • Administrating Oracle Instances

Backup, Restore and Recovery

  • Reviewing a Backup Strategy
  • Reviewing Backup Tools
  • Performing Backups
  • Performing Restore and Recovery
  • Working with Advanced Backup Techniques

Monitors and Tools

  • Introducing Oracle Data Management
  • Managing Database System Check
  • Explaining CCMS Alert Monitor

Space Management

  • Administrating “Table Spaces”
  • Performing Reorganization of Tables
  • Housekeeping and Troubleshooting

Oracle Cache Management

  • Introducing Oracle System Global Area
  • Introducing Automatic Oracle Program Global Area (PGA)

Monitoring of the Database Instance

  • Using the DBA Cockpit to Monitor the Database
  • Understanding the DBA Cockpit support of Oracle database features

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

Index Management and Optimization

  • Utilizing Indexes
  • Creating an Index

Cost-Based Optimizer

  • Updating Statistics
  • Detecting problems with Optimizer statistics

Analysis of Physical and Logical Layout

  • Defragmenting Indexes
  • Working with I/O Contention

Memory Configuration Analysis

  • Describing Data Buffer Utilization
  • Analyzing Efficiency of Shared Pool
  • Monitoring the Automatic Program Global Area (PGA)