Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: size of TableSpace and Performance
DBAOracle wrote:
>
> There are certain cases though that 1x18 might be better than 18x1 FS's... Some
> LVM's will stripe the data for you and there may be cacheing issues as well
> (Veratos is one example). We tested one large file system vs. several smaller
> ones and, all other things being =, got better performance out of the one large
> one, allowing the OS Software to stripe for us... Part of the reason was we
> ended up with a larger cache avalible for read/write on that file system.
>
> Robert
...but you can't stripe over 1 x 18G disk. You can't even mirror. Number of disks is not related to number of file systems...
You can still have a single file system spread over 18 x 1G disks - in fact, this is pretty much what Veritas is for...
Cheers
--
"Some days you're the pigeon, and some days you're the statue." Received on Wed Jul 21 1999 - 08:32:52 CDT