Memory Tuning Techniques

Oracle 12c
  • 11 Videos | 50m 16s
  • Includes Assessment
  • Earns a Badge
Likes 6 Likes 6
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

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

CHANNEL Oracle RAC
Likes 27 Likes 27  
COURSE RAC Tuning
Likes 2 Likes 2  
Likes 19 Likes 19  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 18 Likes 18  
Likes 9 Likes 9  
Likes 27 Likes 27