Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle on NT Performance - again

Re: Oracle on NT Performance - again

From: Sarah Sikes <sikes_at_erols.com>
Date: 1998/02/07
Message-ID: <34dc8f2a.3482868@news.erols.com>#1/1

boulkenospam_at_globalnet.co.uk (Keith Boulton) wrote:

<SNIP>

>I repeated you test on a pentium pro 200. The update statement took
>2.6 seconds. The normal cause of this problem is that the redo log is
>too small. For my test purposes, I have two log files at 50M each,
>with the database running in noarchivelog mode.

...and make sure that your redo_log files are on a physically different disk device than where your data files are located :) Received on Sat Feb 07 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US