Écrit par OCA
|
19-03-2008 |
-
The SGA (System or Shared Global Area) is used to store database
information shared by the processes and is allocated in the virtual
memory of the computer running the Oracle server.
-
The dynamic SGA was introduced with Oracle 9i and allows the SGA configuration to be changed without shutting down the instance.
-
Size of the SGA <= (SGA_MAX_SIZE - (DB_CACHE_SIZE + LOG_BUFFER + SHARED_POOL_SIZE + LARGE_POOL_SIZE + JAVA_POOL_SIZE))
-
A granule is a unit of contiguous virtual memory allocation whose size
depends on the SGA_MAX_SIZE parameter (4MB if SGA_MAX_SIZE<128MB,
16MB otherwise)
SHOW SGA;
|
view SGA memory allocation |
|
Dernière mise à jour : ( 15-04-2008 )
|