SQL Memory Usage Tuning

Oracle 12c    |    Intermediate
  • 6 videos | 23m 24s
  • Includes Assessment
  • Earns a Badge
Rating 4.8 of 4 users Rating 4.8 of 4 users (4)
The SGA is a key component to the effective working of the Oracle database engine. Explore SQL memory usage, the PGA and its role in sort operations, and temporary tablespaces.

WHAT YOU WILL LEARN

  • List memory intensive sql operators and introduce automatic pga memory
    Describe how automatic pga is configured
    Describe how to monitor sql memory usage and discuss the pga advisor
  • Define the use of temporary tablespaces
    Define the concept of temporary tablespace groups and their use
    Discuss administrative commands related to maintaining temporary tablespace

IN THIS COURSE

  • Locked
    1.  SQL Memory Usage
    3m 34s
    After completing this video, you will be able to list memory intensive SQL operators and introduce automatic PGA memory. FREE ACCESS
  • Locked
    2.  Configuring Automatic PGA Memory
    3m 57s
    Upon completion of this video, you will be able to describe how automatic PGA is configured. FREE ACCESS
  • Locked
    3.  Monitoring Automatic PGA Usage
    5m 39s
    Upon completion of this video, you will be able to describe how to monitor SQL memory usage and the PGA advisor. FREE ACCESS
  • Locked
    4.  Temporary Tablespaces
    3m 29s
    Find out how to define the use of temporary tablespaces. FREE ACCESS
  • Locked
    5.  Temporary Tablespace Groups
    3m 20s
    In this video, you will learn about temporary tablespace groups and how to use them. FREE ACCESS
  • Locked
    6.  Temporary Tablespace Maintenance
    3m 26s
    In this video, learn how to discuss administrative commands related to maintaining temporary tablespaces. 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

Channel Wintellect SQL Server
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 Oracle Global Data Services for Mission-critical Systems: Maximizing Performance and Reliability in Complex Enterprise Environments