Tuning Instance Memory

Oracle 12c
  • 11 Videos | 55m 19s
  • Includes Assessment
  • Earns a Badge
When performance tuning in Oracle Database 12c, it's vital to include the System Global Area in your efforts. Explore SGA tuning, including using AWR reports, adaptive cursor sharing, and the SQL query result cache.

WHAT YOU WILL LEARN

  • 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
    define the concept of a hard parse and optimizing the use of cursors
    describe the concept of adaptive cursor sharing
  • describe how to properly size the shared pool
    discuss ways to reduce fragmentation within the shared pool
    discuss the SQL query result cache feature
    describe the DBMS_RESULT_CACHE package and considerations when using the SQL query result cache feature
    identify large objects and configure them to be retained in the shared pool

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

COURSE RAC Tuning
Likes 2 Likes 2  
COURSE SQL Tuning
Likes 20 Likes 20