Re: SGA size

From: <satar_at_my-dejanews.com>
Date: Wed, 16 Sep 1998 20:42:00 GMT
Message-ID: <6tp7qo$s6f$1@nnrp1.dejanews.com>

Hi Bertalan Gombos,
It is comprised of the following:
Fixed Size - which I forget what it is
Variable Size - the "shared_pool_size" setting in the init<sid>.ora file Database Buffers - the "db_block_buffers" setting in the init<sid>.ora file Redo Buffers - the "log_buffer" setting in the init<sid>.ora file

You can do the following to check the SGA: select * from v$sga;

Also, keep in mind that the db_block_buffer setting is in blocks, not bytes. For example, my db_block_buffers setting is 100,000 (db_block_buffers = 100000), so my Database Buffers setting is 204800000 (100000 * 2k block size).

Good Luck,
Satar
In article <35FFE7DE.B652D93C_at_finit.hu>, bgombos_at_freemail.c3.hu wrote:
> Hi all!
>
> How can I set the size of SGA? I haven't found any parameter in
> INIT.ORA which set the SGA size.
>
> Thanks, bye:
> Bert
> --
> :
> ----.----, ------------------------------:----------------------------
> --;----"-----, ,--------, ,--------, | Bertalan Gombos
> | | ;--------' | | software engineer
> ---|----------' `-------- | | bgombos_at_freemail.c3.hu
> `----' --------------------------------- `------------------------ '98
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Sep 16 1998 - 15:42:00 CDT