Re: Q:Good preformance

This is a highly platform specific question. Many people have inadverntely harmed their performance by increasing the block size. This is a questionable piece of generic advice.

The best way to tune performance is to tune your queries. You should also monitor your database to see if you are over using a specific resource, like shared pool. The UTLBSTAT and UTLESTAT scripts are a good place to start. (Check the spelling, I don't have my Oracle reference handy).

There are several factors that affect block IO including db_block_size. Are you accessing data randomly or sequentially. If you are accessing data randomly increasing your db_bloc_size may hurt your performance.

Sanlam wrote:
>
> Hi
>
> For one you could increase the block size to 8192, 16384 etc. if your O/S
> allows you to. I see you have lots of rollback segments. It will help if
....

> > Hello
> > I've got the following INIT.ORA file, does anybody know who I can
> > tune the INIT.ORA file for best preformance. I've got lots of inserts and
> > updates in my applikation.
> >
> > //Martin
> >
Received on Mon Sep 22 1997 - 00:00:00 CEST