Re: What is the SGA...
From: Oneal L. Bishop <BISHOP.MSUSINSP_at_EDS.COM>
Date: 1996/05/22
Message-ID: <31A33184.5177_at_EDS.COM>#1/1
Date: 1996/05/22
Message-ID: <31A33184.5177_at_EDS.COM>#1/1
Peter Rak wrote:
>
> What is SGA??? In Oracle the architecture uses internal memory structures, of
which SGA (System Global Area) is one of these structures. It faciitates
the transfer of information between users. It also holds commonly
requested structural information about the database--data block buffers,
redo log buffers, and dictionary cache is part of the shared SQL pool for
Oracle 7. For Oracle 6 exclude the SQL pool -- data block buffers, redo
log buffers, and standalone dictionary cache without a shared SQL pool.
The SGA sizing is under control of parameters found within INIT.ORA (i.e. DB_BLOCK_BUFFERS, SHARED_POOL_SIZE, DC_TABLES, LOG_BUFFER)
-- Ãà à ¡± áReceived on Wed May 22 1996 - 00:00:00 CEST