Re: QUESTION: Oracle 8.0.4 parameters datawarehouse environment

Hi Jouke,

start running utlbstat/utlestat in the rdbms/admin directory, or use the checktuning script on
http://www.ipass.net/~davesisk/oont.htm This will allow you at least to make measurable improvements. If you are using default parameters, they are way too low. DB_BLOCK_BUFFERS should result in 16M cache minimum, shared pool size minimum is some 40M, log_buffer should be at least 32 or 64k. If there is any method to get that OLTP stuff, you really shouldn't use 2k for datawarehouse activities. 8k minimum. Otherwise you can tune what you want, and it still won't work.

Hth,

Sybrand Bakker, Oracle DBA

Jouke Wilkens <jouke.wilkens_at_tip.nl> wrote in message news:7o7m3o$6i1$1_at_news.worldonline.nl...
> What are the most common values for parameters in a
datawarehouse-database?
> At our company we have a (datawarehouse-)database with most of the
> parameters as default.
> Our knowledge about those parameters is not as good as we wish, because
the
> performance of our
> database is bad. We can do trial and error, but maybe there is a good
> default setting for a datawarehouse-
> environment.
> Unfortunately our database is also used for OLTP transactions and the
> DB_BLOCK_SIZE = 2048.
>
> Who can help us?
>
> Thanks, Jouke Wilkens
> jouke.wilkens_at_tip.nl
>
>
>
>
>
Received on Tue Aug 03 1999 - 17:34:08 CDT