Performance Tuning Summary

Oracle 12c    |    Intermediate
  • 7 videos | 30m 8s
  • Earns a Badge
Rating 5.0 of 9 users Rating 5.0 of 9 users (9)
To fully tune your database, you need a solid understanding of manipulating SGA components and Automatic Memory Management Maintenance. Learn about these Oracle Database 12c concepts.

WHAT YOU WILL LEARN

  • Describe the concept of a dynamic sga and introduce the concept of granules
    Describe parameters relevant to dynamic sga and how to increase the size of a sga component
    Describe how sga parameters behave when configured against an auto-tuned versus manually-tuned sga
    Describe administrative operations such as resizing, enabling, and disabling asmm
  • Describe the concept of automatic memory management and how it differs from asmm
    Describe how to enable and monitor automatic memory management
    Configure automatic shared memory management

IN THIS COURSE

  • Locked
    1.  Dynamic SGA
    5m 9s
    Upon completion of this video, you will be able to describe the concept of a dynamic SGA and introduce the concept of granules. FREE ACCESS
  • Locked
    2.  Manipulating SGA Components
    4m 16s
    Upon completion of this video, you will be able to describe parameters relevant to dynamic SGA and how to increase the size of a SGA component. FREE ACCESS
  • Locked
    3.  Behaviour of SGA Parameters
    3m 54s
    After completing this video, you will be able to describe how SGA parameters behave when configured against an auto-tuned SGA versus a manually-tuned SGA. FREE ACCESS
  • Locked
    4.  ASMM Maintenance
    3m 40s
    After completing this video, you will be able to describe administrative operations such as resizing, enabling, and disabling ASM. FREE ACCESS
  • Locked
    5.  Automatic Memory Management
    3m 21s
    After completing this video, you will be able to describe the concept of automatic memory management and how it differs from manual memory management. FREE ACCESS
  • Locked
    6.  Automatic Memory Management Maintenance
    3m 57s
    Upon completion of this video, you will be able to describe how to enable and monitor automatic memory management. FREE ACCESS
  • Locked
    7.  Exercise: Use the Automatic Memory Tuning Function
    5m 51s
    In this video, learn how to configure automatic shared memory management. 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

Course Oracle Database 12c R2 SQL: Using Structured Query Language (SQL)
Rating 4.6 of 255 users Rating 4.6 of 255 users (255)
Course Database Fundamentals: Understanding Relational Database Management Systems
Rating 4.5 of 173 users Rating 4.5 of 173 users (173)
Course CompTIA Data+: Database Concepts
Rating 4.6 of 21 users Rating 4.6 of 21 users (21)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Database Maintenance
Rating 4.6 of 34 users Rating 4.6 of 34 users (34)
Course Tuning Problem SQL Statements
Rating 4.4 of 9 users Rating 4.4 of 9 users (9)
Course RAC Administration Services & Multitenant Architecture
Rating 4.7 of 15 users Rating 4.7 of 15 users (15)