Re: Tuning oracle database

1 db_block_size : at least 4k
2 db_block_buffers: at least 2000 (based on 4k), but 5000 is probably more like it.
3 shared_pool_size: at least 10 to 20 M
4 sort_area_size at least 262144 (256k) but better still 1048576 (1M) 5 online redo log files: at least 4 of 5M each, sw mirrored.

Hth,

Sybrand Bakker, Oracle DBA

"Axel Pötzinger" <a.poet_at_freenet.de> wrote in message news:8kkqdp$r9h$11$1_at_news.t-online.com...
> Hi,
>
> could anybody please give us some hints what are the most common means to
> tune an oracle database. what default values should be increase to what
 size
> .......
>
> Axel
>
>
>
Received on Thu Jul 13 2000 - 00:00:00 CDT