Database Usage of Unix FFS
From: Lee E Parsons <lparsons_at_world.std.com>
Date: Tue, 22 Feb 1994 15:16:23 GMT
Message-ID: <CLMt3D.35o_at_world.std.com>
Date: Tue, 22 Feb 1994 15:16:23 GMT
Message-ID: <CLMt3D.35o_at_world.std.com>
Situation: Large database files are the only files on a group of UNIX
Fast FileSystem partitions. These files are created by the
database on initialization and if any are deleted all
are deleted. The files would likely be 50 to 100mb each.
1 partition = 1 drive.
(I/O distribution considerations aside. Of course.)
2) Since no deletes are happening you don't have to worry about holes
in the data. ie) you won't have 100 meg in the middle of the drive
you need to use.
Even if you needed to add an additional datafile it would just get slapped on the end of the last datafile in one contiguous space.
-- Regards, Lee E. Parsons Systems Oracle DBA lparsons_at_world.std.comReceived on Tue Feb 22 1994 - 16:16:23 CET