From the course: Learning Oracle Database 12c
Join today to access over 25,300 courses taught by industry experts.
Memory - Oracle Database Tutorial
From the course: Learning Oracle Database 12c
Memory
- [Narrator] Let's talk about Database Architecture, in particular, the Memory components. There are three primary architectural areas that you need to understand when working with Oracle Database. Those three are Memory structure, Process structures, and Storage structures. We'll cover Memory structures in this video, Process structures and Storage structures will be covered in other videos. Oracle Memory structures can be broken down into two primary components. System Global Area, also known as the SGA, and the Program Global Area, PGA. Those are highlighted in the diagram on the right. Let's break down the SGA and PGA a little bit more. SGA contains shared Memory structures, in other words, shared by all users and processes in the database. It's controlled by one database instance on the server. It contains things like, database data blocks, shared SQL statements, and other structures. The PGA on the other hand,…
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.