Database Administration Oracle II

Product type

Database Administration Oracle II

SAP Training
Logo SAP Training
Provider rating: starstarstarstar_halfstar_border 6.5 SAP Training has an average rating of 6.5 (out of 2 reviews)

Need more information? Get more details on the site of the provider.

Description

Goals

  • Describe memory management in the Oracle database
  • Regularly monitoring of an Oracle database with the SAP database monitor
  • Analyzing and optimizing database performance

Audience

  • System Administrator
  • Database Administrator
  • Technology Consultant

Prerequisites

Essential
  • ADM505
Recommended
  • none

Course based on software release

  • SAP ERP 6.05
  • Oracle 11g

Content

  • 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 Im…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Enterprise Resource Planning (ERP), Logistics, Linux, Oracle 10G, and CompTIA A+ / Network+ / Security+.

Goals

  • Describe memory management in the Oracle database
  • Regularly monitoring of an Oracle database with the SAP database monitor
  • Analyzing and optimizing database performance

Audience

  • System Administrator
  • Database Administrator
  • Technology Consultant

Prerequisites

Essential
  • ADM505
Recommended
  • none

Course based on software release

  • SAP ERP 6.05
  • Oracle 11g

Content

  • 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)
  • Wait Interface and Automatic Workload Repository
    • Observing Oracle Wait Interface
    • Reviewing Automatic Workload Repository and Histories

Notes

  • Optimizing database parameters and the hardware configuration are not covered as part of this course

Popular tags

No tags submitted for this course yet

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.