Re: Concurrence problems on oracle8 run with linux

From: Anton Dischner <dischner_at_med.uni-muenchen.de>
Date: Thu, 26 Nov 1998 17:28:20 +0100
Message-ID: <dischner-2611981728200001@klchmc1.klch.med.uni-muenchen.de>

In article <365AFD3A.2EC723C4_at_despodata.pt>, cpatrao_at_despodata.pt wrote:

> I have installed the Oracle8 server version 8.0.5 in a Debian GNU/Linux
> 2.0 using the
> kernel 2.0.34 compiled for optimize the Oracle server, apparently
> everything works fine but when I run two processes who make inserts in
> de same table(without rows and indexes) the performance it's very bad. I
> believe that's a tuning problem, but I have short experience with
> ORACLE8 a I need advises to resolve this problem

A first try is to make the SGA in your initSID.ora file greater. Experiment with different sizes.
Try to use indexes whenever possible. It's worth the extra space.

Kind regards and greetings to Lisboa,

Toni Received on Thu Nov 26 1998 - 10:28:20 CST