Re: separate data/inidex

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 22 Apr 2002 14:38:40 +0100
Message-ID: <1019482651.22742.0.nnrp-08.9e984b29@news.demon.co.uk>

And that only worked on VAX, I believe.

UNIX filesystems even have (had) a
parameter to restrict how much of a
single file would be created on a single track before the heads were moved on
a track anyway. Not sure what the reasoning was - possibly something to do with leaving space in the track for updates to the file, but a bad idea as far as Oracle files were concerned.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Author of:
Practical Oracle 8i: Building Efficient Databases

Next Seminar - Australia - July/August
http://www.jlcomp.demon.co.uk/seminar.html

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html



Thomas Kyte wrote in message ...


>

>files are not contigous in general (we wouldn't have to defrag if they

were).


>At least not since you had to use the CCF tool in v5 to create a file

(create


>contigous file).

>

Received on Mon Apr 22 2002 - 08:38:40 CDT