Database 2 2024/2025 Lecture 6 PDF

Elective-course (3) Database (2) 2024/2025 Lecture 6 Assis. Prof. Dr. Elmahdy Maree Exploring the Oracle Database Architecture MET Database II Oracle Database Architecture...

Elective-course (3) Database (2) 2024/2025 Lecture 6 Assis. Prof. Dr. Elmahdy Maree Exploring the Oracle Database Architecture MET Database II Oracle Database Architecture An Oracle database consists of an instance and its associated databases. The instance consists of memory structures and background processes. Every time an instance is started, a shared memory area called the System Global Area (SGA) is allocated and the background processes are started. The database consists of both physical structures and logical structures. Because the physical and logical structures are separate, the physical storage of data can be managed without affecting access to logical storage structures 2024 / 2025 MET Database II 2024 / 2025 MET Database II Oracle Database Memory Structures Oracle Database creates and uses memory structures for various purposes. For example, memory stores program code being run, data that is shared among users, and private data areas for each connected user. Two basic memory structures are associated with an instance: System Global Area (SGA): Group of shared memory structures, known as SGA components, that contain data and control information for one Oracle Database instance. The SGA is shared by all server and background processes. Examples of data stored in the SGA include cached data blocks and shared SQL areas. Program Global Areas (PGA): Memory regions that contain data and control information for a server or background process. A PGA is nonshared memory created by Oracle Database when a server or background process is started. Access to the PGA is exclusive to the server process. Each server process and background process has its own PGA. 2024 / 2025 MET Database II 2024 / 2025 MET Database II 2024 / 2025 MET Database II 2024 / 2025 MET Database II 2024 / 2025 MET Database II 2024 / 2025 MET Database II 2024 / 2025 MET Database II 2024 / 2025 MET Database II 2024 / 2025 MET Database II 2024 / 2025 MET Database II 2024 / 2025 MET Database II 2024 / 2025 MET Database II 2024 / 2025 MET Database II 2024 / 2025 MET Database II 2024 / 2025 MET Database II 2024 / 2025 MET Database II 2024 / 2025 MET Database II 2024 / 2025 MET Database II 2024 / 2025 MET Database II 2024 / 2025 MET Database II 2024 / 2025 MET Database II 2024 / 2025 MET Database II 2024 / 2025 Questions