Re: ... value-recommendations for a very large SGA and else?

The is not much information to go on here, but :

The block size is indeed set at database creation time and can not be subsequently changes (select a block size to suit your application, e.g.8k block for DSS or 4k for OLTP).

Assuming 256Mb of memory on the server dedicated to a single Oracle Instance :

If your system has much shared sql or lots of PL/SQL then make sure that shared_pool_size is large enough, say 50+Mb. If your system has many session accessing the data the make sure db_block_buffers is large enough, say 120Mb for 20 users. If users are likely to be doing large group by, order by etc then start sort_area_size at 2Mb and increase as appropriate. Always make sure the redo logs are large enough (I see loads of systems with 200k redo logs) aim to switch log in the order of every 15min which usually means 20+Mb redo logs.

Regards
David Russell
Ralf Schneider wrote in message <6r78j1$skr$1_at_unlisys.unlisys.net>...
>Ja aber Hallo!
>
>How have I to use the init<sid>.ora parameter "db_block_size"; permanent or
>only at the "create db" time?
>Further, could somebody recommend values for a very large SGA? (around
about
>150MB)
>sort_area_size = ?
>sort_area_retained_size = ?
>db_block_buffers = ?
>shared_pool_size = ?
>log_buffer = ?
>... and maybe for dependent parameters too!
>
>Many Thanks
>Ralle
>
>
Received on Sun Aug 16 1998 - 15:33:22 CDT