SQL Memory Usage Tuning
Oracle 12c
| Intermediate
- 6 videos | 23m 24s
- Includes Assessment
- Earns a Badge
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
-
1. SQL Memory Usage3m 34sAfter completing this video, you will be able to list memory intensive SQL operators and introduce automatic PGA memory. FREE ACCESS
-
2. Configuring Automatic PGA Memory3m 57sUpon completion of this video, you will be able to describe how automatic PGA is configured. FREE ACCESS
-
3. Monitoring Automatic PGA Usage5m 39sUpon completion of this video, you will be able to describe how to monitor SQL memory usage and the PGA advisor. FREE ACCESS
-
4. Temporary Tablespaces3m 29sFind out how to define the use of temporary tablespaces. FREE ACCESS
-
5. Temporary Tablespace Groups3m 20sIn this video, you will learn about temporary tablespace groups and how to use them. FREE ACCESS
-
6. Temporary Tablespace Maintenance3m 26sIn 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
Apache Cassandra