Re: slow update, what to look for?

In article <MPG.14dbdb8e5567b3d4989680_at_192.168.0.1>,   hegyvari_at_ardents.hu wrote:
> Greetings,
>
> We are developing for the web using Oracle 8 on a Linux as a database
> server. One thing I have noticed and it really is frustrating by now,
> that update statements run much slower than any select or insert
> statements. This is more than true when I try to use correlated
 updates.
> I understand that update is the most resource-consuming of the lot,
 but I
> suspect that there can be things done around the rollback segments or
> anywhere else to tune the database. The current configuration is
> basically the default (I accepted the option of creating the database
> during install). I have changed the init...ora file to the LARGE
 default
> values, but so for that was all. I searched the manuals for some
> practical advice, but found none. Could someone please enlighten me
 what
> I should try to change on my Oracle setup to get better results? The
> server has 512M RAM, fast disks, fast processor, it should not be a
> problem.
>
> Any info is highly appreciated,
>
> Hegyvari Krisztian
>

You have not stated the problem. What is slow? How many updates per minute.

What is your configuration : # and type of CPU, how many controler cards, SGA size, how many disks, how big of data set, etc

Most of my development (even with on NT, running Oracle on my local work station) updating a row was nearly instantaneous.

As a rule, IMHO no one ever uses the default Oracle setup -- too small for almost anything, no rollback segments, etc.

--
Michael Krolewski
Rosetta Inpharmatics
mkrolewski_at_rii.com
              Usual disclaimers


Sent via Deja.com
http://www.deja.com/