Their has been a lot of talk regarding the SGA details of
Oracle. And a lot people even get confused when talking of various processes in
memory and buffer of Oracle. So here we will discuss some of the important
process and buffer details of Oracle SGA (system Global Area).
A system global area (SGA) is a group of shared memory
structures that contain data and control information for one Oracle database
instance. If multiple users are concurrently connected to the same instance,
then the data in the instance's SGA is shared among the users. Consequently,
the SGA is sometimes called the shared global area.
