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: separate data/inidex

Re: separate data/inidex

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Mon, 6 May 2002 12:31:36 +0100
Message-ID: <3cd66998$0$8513$cc9e4d1f@news.dial.pipex.com>


"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:1020683797.19441.0.nnrp-08.9e984b29_at_news.demon.co.uk...

>

> But how much of the performance impact might be
> due to NT systems being used in a somewhat
> cavalier fashion - lots of little files get created and
> dropped over time leaving lots of file fragments,
> and then Oracle files get extended, moved,
> recreated in the gaps. As per your comments
> about sharing partitions with other folders
> and moving big data files.

this is obviously true - especially given the number and frequency of patches to the OS. however it is still worth as an eyeopener installing NT/2k only on a machine (server or workstation doesn't matter) and then immediately run a defragmentation utility.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
Received on Mon May 06 2002 - 06:31:36 CDT

Original text of this message

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