Course Details

Previous Page


Oracle 12c Performance Tuning: Tuning Instance Memory


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number



Overview/Description
The SGA a key component to the effective working of the Oracle database engine. This course covers the SGA as well as topics such as the buffer cache, which enhances database I/O, the shared pool, which is key to application scalability, and the PGA and its role in sort operations. This course is one of a series in the SkillSoft learning path that cover the objectives for the Oracle Database 12c: Performance Management and Tuning exam (1ZO-064).

Target Audience
Database Administrators, Application Developers, Technical Consultants.

Prerequisites
None

Expected Duration (hours)
2.2

Lesson Objectives

Oracle 12c Performance Tuning: Tuning Instance Memory

  • start the course
  • describe the components that make up the shared pool
  • define the terms latch and mutex
  • use dictionary views and AWR to provide tuning information for the shared pool
  • use sections of an AWR report to provide tuning information for the shared pool
  • describe how to optimize the use of cursors
  • describe the concept of adaptive cursor sharing
  • describe how to properly size the shared pool
  • describe ways to reduce fragmentation within the shared pool
  • describe the SQL query result cache feature
  • describe the DBMS_RESULT_CACHE package and considerations when using the SQL query result cache feature
  • describe the Oracle database architecture in terms of the buffer cache
  • describe the use of the buffer hash table
  • describe the goals and techniques relevant to tuning the buffer cache
  • identify examples of buffer cache contention
  • describe parameters related to the buffer cache size
  • use the buffer cache advisor
  • list the conditions under which multiple buffer pools may be needed
  • list the ways in which the dbwr background process can be optimized to allow higher throughput
  • describe further mechanisms related to disk throughput and the buffer cache
  • describe how Database Smart Flash Cache can extend the buffer cache
  • configure and specify devices for the Database Smart Flash Cache
  • list memory intensive SQL operators
  • describe how automatic PGA is configured
  • describe how to monitor SQL memory usage and discuss the PGA advisor
  • define the use of temporary tablespaces
  • define the concept of temporary tablespace groups and their use
  • describe administrative commands related to maintaining temporary tablespace
  • identify large objects and configure them to be retained in the shared pool
  • Course Number:
    od_pmte_a07_it_enus