Tuning Instance Memory

Oracle 12c    |    Intermediate
  • 11 videos | 50m 19s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 5 users Rating 4.6 of 5 users (5)
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

  • Locked
    1.  Shared Pool Architecture
    5m 7s
    Upon completion of this video, you will be able to describe the components that make up the shared pool. FREE ACCESS
  • Locked
    2.  Latch and Mutex
    3m 40s
    Find out how to define the terms "latch" and "mutex." FREE ACCESS
  • Locked
    3.  Tuning the Shared Pool
    2m 26s
    In this video, you will learn how to use dictionary views and AWR to provide tuning information for the shared pool. FREE ACCESS
  • Locked
    4.  Using AWR Reports to Tune the Shared Pool
    5m 10s
    To find out how to use sections of an AWR report to provide tuning information for the shared pool, consult the Oracle documentation. FREE ACCESS
  • Locked
    5.  Parsing and Cursor Sharing
    4m
    Learn how to define the concept of a hard parse and how to optimize the use of cursors. FREE ACCESS
  • Locked
    6.  Adaptive Cursor Sharing
    5m 10s
    After completing this video, you will be able to describe the concept of adaptive cursor sharing. FREE ACCESS
  • Locked
    7.  Sizing the Shared Pool
    5m 3s
    After completing this video, you will be able to describe how to properly size the shared pool. FREE ACCESS
  • Locked
    8.  Fragmentation Within the Shared Pool
    4m 41s
    During this video, you will learn how to discuss ways to reduce fragmentation within the shared pool. FREE ACCESS
  • Locked
    9.  SQL Query Result Cache: Part 1
    5m 16s
    In this video, you will discuss the SQL query result cache feature. FREE ACCESS
  • Locked
    10.  SQL Query Result Cache: Part 2
    2m 55s
    After completing this video, you will be able to describe the DBMS_RESULT_CACHE package and considerations when using the SQL query result cache feature. FREE ACCESS
  • Locked
    11.  Exercise: Keep Objects in the Shared Pool
    6m 51s
    Learn how to identify large objects and configure them to retain in the shared pool. 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.

YOU MIGHT ALSO LIKE

Book Modern Oracle Database Programming: Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, PL/SQL, and JSON
Book Expert Performance Indexing in Azure SQL and SQL Server 2022: Toward Faster Results and Lower Maintenance Both on Premises and in the Cloud, 4th Edition
Course Introduction to Performance Tuning
Rating 4.5 of 32 users Rating 4.5 of 32 users (32)