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


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

Original text of this message