From the course: Learning Oracle Database 19c
Join today to access over 25,300 courses taught by industry experts.
Memory, storage, and processes - Oracle Database Tutorial
From the course: Learning Oracle Database 19c
Memory, storage, and processes
- [Instructor] The Oracle database server architecture consists of three important components that you'll need to deal with on a daily basis as a DBA: memory, storage, and processes. I'll review all three of these at a high level so you understand where table data and user sessions reside when they reside in the server's memory. The server architecture for Oracle database can be divided into three areas: memory structures, operating system process structures, and storage structures. The server memory contains the memory structures, the SGA, and the PGA. The client in the lower left corner uses both the PGA and SGA for temporarily holding data from their tables. Part of the memory is occupied by the server processes, the chunks of Oracle code that manage your server and respond to user requests. The client in the lower left corner interacts with the server processes by making requests for reading and writing data via SQL statements. A large part of the storage architecture in the…
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.