From the course: Oracle Database 12c: Administration
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Other SGA pools and the PGA - Oracle Database Tutorial
From the course: Oracle Database 12c: Administration
Other SGA pools and the PGA
- [Narrator] Woof. That was a long explanation for such a small component of the Oracle Instance, literally. The largest component of the SGA is usually the buffer cache. As it caches actual data read from disk. In rows, lots of rows from, you know, tables, lots and lots of tables. The second largest cache in the SGA is usually the shared pool. It stores the past presentation of single statements as well as metadata. This leaves us with the RedoLog Buffer. Usually making it the smallest of the major components in the SGA. But alas we are not done just yet. Bare with me for a few more minutes as we briefly go over several other SGA components. Some of them are not nearly as important for our daily administration of the oracle database as the shared pool, buffer cache and redolog buffer. But we still need to know about their functions in the SGA. Next on our list of SGA components galore is the large pool. We won't go into a lot of details as the large pool isn't nearly as important as…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.