Memory Tuning Techniques

Oracle 12c    |    Intermediate
  • 11 videos | 45m 16s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 16 users Rating 4.5 of 16 users (16)
The SGA a key component to the effective working of the Oracle database engine. Learn about SGA tuning, including tuning the buffer cache and I/O.

WHAT YOU WILL LEARN

  • Describe the oracle database architecture in terms of the buffer cache
    Discuss the use of the buffer hash table
    Describe the goals and techniques relevant to tuning the buffer cache
    Discuss how to identify how segments and diagnose buffer busy waits
    Discuss how to identify further buffer cache related waits and parameters related to the buffer cache
    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
    Discuss 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

IN THIS COURSE

  • Locked
    1.  Oracle Database Architecture
    3m 23s
    Upon completion of this video, you will be able to describe the Oracle database architecture in terms of the buffer cache. FREE ACCESS
  • Locked
    2.  Buffer Cache Internals
    2m 45s
    In this video, you will learn how to discuss the use of the buffer hash table. FREE ACCESS
  • Locked
    3.  Tuning Goals and Techniques
    5m 18s
    After completing this video, you will be able to describe the goals and techniques relevant to tuning the buffer cache. FREE ACCESS
  • Locked
    4.  Buffer Cache Contention: Part 1
    4m 25s
    In this video, you will discuss how to identify segments and diagnose buffer busy waits. FREE ACCESS
  • Locked
    5.  Buffer Cache Contention: Part 2
    4m 45s
    In this video, you will discuss how to identify further buffer cache related waits and parameters related to the buffer cache. FREE ACCESS
  • Locked
    6.  The Buffer Cache Advisor
    3m 41s
    Learn how to use the buffer cache advisor. FREE ACCESS
  • Locked
    7.  Multiple Buffer Pools
    4m 45s
    After completing this video, you will be able to list the conditions under which multiple buffer pools may be needed. FREE ACCESS
  • Locked
    8.  Background Processes and the Buffer Cache
    3m 53s
    Upon completion of this video, you will be able to list the ways in which the dbwr background process can be optimized to allow for higher throughput. FREE ACCESS
  • Locked
    9.  I/O Tuning and the Buffer Cache
    3m 31s
    In this video, learn how to discuss additional mechanisms related to disk throughput and the buffer cache. FREE ACCESS
  • Locked
    10.  Database Smart Flash Cache
    4m 24s
    After completing this video, you will be able to describe how database smart flash cache can extend the buffer cache. FREE ACCESS
  • Locked
    11.  Using Database Smart Flash Cache
    4m 27s
    In this video, learn how to configure and specify devices for the database smart flash cache. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.5 of 354 users Rating 4.5 of 354 users (354)
Rating 4.5 of 10 users Rating 4.5 of 10 users (10)
Course SQL Developer
Rating 4.5 of 583 users Rating 4.5 of 583 users (583)