Re: kernel/init parameters

Hi Deepak,

At 13:15 12/05/2000 -0800, you wrote:

>SGA = (db_block_buffers * db_block_size) + 


>       shared_pool_size +

>       sort_area_size + 

>       overhead


You forgot the Redo Log Buffer size .

Also, if you don't use Oracle in multithreaded configuration (MTS), sort areas are not located in the SGA.

Regards

Gilles Parc
Email : gparc_at_mail.dotcom.fr Received on Mon May 15 2000 - 03:59:41 CDT