Oracle Database creates and uses memory structures for program code, data shared among users, and private data areas for each connected user.
cisco certification training courses malaysia
The following memory structures are associated with a database instance:
- System Global Area (SGA)The SGA is a group of shared memory structures that contain data and control information for one database instance. Examples of SGA components include the database buffer cache and shared SQL areas. Starting in Oracle Database 12c Release 1 (12.1.0.2), the SGA can contain an optional In-Memory Column Store (IM column store), which enables data to be populated in memory in a columnar format.
ccnp certification training courses malaysia - Program Global Areas (PGA)A PGA is a memory region that contains data and control information for a server or background process. Access to the PGA is exclusive to the process. Each server process and background process has its own PGA.See also”Memory Architecture”
ccie certification training courses malaysia
See also
“Memory Architecture”
Leave a Reply