From the course: Oracle Database 12c: Administration
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
System global area - Oracle Database Tutorial
From the course: Oracle Database 12c: Administration
System global area
- [Instructor] Say hello to the Oracle Instance in all its glory. Beautiful, isn't it? Previously, when introducing the function of the Oracle Instance, we treated it as a single unit that serves the function of caching data and performing routine operations required for transactional processing via a set of background processes. But that is just scratching the surface. The Oracle Instance is actually more complex than that. And now is the time for us to pull back the curtain and take a peek inside. The first part of the Oracle Instance you need to be familiar with is called the SGA, or system global area. It might seem a bit confusing, at first, but bear with me, as there is logic to the naming. The SGA is the first part of the Oracle Instance that is used to cache data and metadata in memory. The second part being the Oracle background processes, which we will talk about in our next chapter. The SGA is a group of shared memory structures, known as individual SGA components, which…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.