Re: Tuning oracle database

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:963507966.1643.1.pluto.d4ee154e_at_news.demon.nl...
> 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.
>

Yeah. And my aunty used to be Cary Grant on alternate Thursdays, too.

Where do you get these numbers??! Until you know how many concurrent users he has, I can't see how you can reasonably propose a sort_area_size. Suppose he has a thousand users. You really want him to have a Gigabyte of sort_area_size??

DB_BLOCK_SIZE?? Depends on his operating system, and on whether performance is king -but 16K blocks these days is a bit of a no brainer.

How do you propose a number of online redo logs, until you've seen his alert log and the rate at which he is proposing to switch logs? The number of logs is governed almost enitrely by the rate at which log switches occur. The size of each log is governed almost enitrely by the rate at which he wants to checkpoint and the speed with which he wishes to recover the database in the event of failure.

In short: Your numbers are gibberish.

The polite answer to his original question is, 'no, there are no shortcuts to working out how your database is behaving, how you want it to behave, and learning how to turn the one state of affairs into the other.'

HJR
> 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 Sat Jul 15 2000 - 00:00:00 CDT