From: "Niall Litchfield" <n-litchfield@audit-commission.gov.uk>
Subject: Re: Is it me or is Oracle just slow?
Date: 2000/06/06
Message-ID: <8hic5n$81d$1@soap.pipex.net>#1/1
References: <8h4f6n$1s1$1@slb0.atl.mindspring.net> <8hgdis$271$1@nnrp1.deja.com>
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
X-Complaints-To: abuse@uk.uu.net
X-Trace: soap.pipex.net 960279543 8237 193.128.236.219 (6 Jun 2000 08:19:03 GMT)
Organization: UUNET WorldCom server (post doesn't reflect views of UUNET WorldCom
X-MSMail-Priority: Normal
NNTP-Posting-Date: 6 Jun 2000 08:19:03 GMT
Newsgroups: comp.databases.oracle.marketplace,comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools


<tandym@hotmail.com> wrote in message news:8hgdis$271$1@nnrp1.deja.com...
> Hi,
>
> a couple of ideas -

<snip>
> Then, make sure you
> are not running in archive log mode (this will slow you down too).

<snip>

With properly thought out disk locations running in archive log mode
shouldn't make a noticeable difference to your system and unless the db is
just a play thing you probably want to be able to recover following a
failure. Archive log is definitely recommended.

Niall



--
Niall Litchfield
Oracle DBA
Audit Commission UK