SQL Memory Usage Tuning

Oracle 12c
  • 6 Videos | 26m 24s
  • Includes Assessment
  • Earns a Badge
Likes 4 Likes 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

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