Re: Why moving indices to a seperate file declines the INSERTS?

From: <nasof_at_hotmail.com>
Date: Mon, 28 Sep 1998 20:09:03 GMT
Message-ID: <6uoqcv$2k0$1@nnrp1.dejanews.com>

In article <6uoc1r$3le$1_at_newsin-1.starnet.net>, "Adam Tadjkarimi" <adamt_at_hsltd.com> wrote:
> I've inherited a small database (~5 gig) with some design and performance
> problems. One the
> first things I noticed the data and indices reside on the same tablespace, I
> moved the indices to a
> separate file. To very much of my surprise the performance declined
> drastically for INSERT transactions!!!?, shouldn't it have been other way
> round?
>
> Environment: NT4.0, Oracle 8.04
>
> Thanks in advance,
> Adam Tadj
>
> adamt_at_hsltd.com
>
> Opinions expressed or questions asked are mine not of my employer.
>

Did you move them to a separate file on another disk, or on the same disk? If you moved them to a separate disk, what else is on that disk (i.e. did you move them to a slow heavily used disk?)

-Frank
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Mon Sep 28 1998 - 15:09:03 CDT