From the course: Complete Guide to Oracle Database 23ai: From Beginner to Advanced

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Oracle memory and processes

Oracle memory and processes - Oracle Database Tutorial

From the course: Complete Guide to Oracle Database 23ai: From Beginner to Advanced

Start my 1-month free trial Buy for my team

Oracle memory and processes

“

- [Instructor] As we move from physical and logical architecture, we must review how memory is used in Oracle along with the background processes. Memory is allocated to an Oracle instance, or in the case of RAC, Oracle instances, and used by each instance for its own system global area, also known as the SGA. Background processes perform tasks, many of them determined by the process designation, along with foreground processes from clients and applications connecting via database listener process, which consistently checks for new connections. All PDBs are plugged into the CDB, and it possesses the metadata required to oversee the PDB's background processes, allowing for more efficient sharing of resources. In this demo, we're going to talk about how we can go in and look at information inside the database for SGA and PGA, both from looking at the parameters as well as querying the data dictionary. We can do this very quickly by typing in the show parameter command and then typing in…

Contents