Re: How fast is Oracle ?
From: Gary Gapinski <gapinski_at_lerc.nasa.gov>
Date: 1996/02/08
Message-ID: <4fdii1$f3k_at_bytor.lerc.nasa.gov>#1/1
Date: 1996/02/08
Message-ID: <4fdii1$f3k_at_bytor.lerc.nasa.gov>#1/1
Ditto the previous comments about array usage. I don't think parallelism will work if the inserts or updates are hitting the same table or indices.
Also, Oracle works best on six or more spindles (and controllers). Split tables, indices, rollback, logs, archive logs, and temp spaces if possible. Further twiddling in the init.ora is necessary to tune for cheap I/O. You may wish to drop your blocksize to 2048 if it is above that (db create is necessary to do this).
Regards,
Gary
-- __________________________________________________________ Gary Gapinski email: gapinski_at_lerc.nasa.gov NASA Lewis Research Center voice: +1 216 433 5251Received on Thu Feb 08 1996 - 00:00:00 CET