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: size of TableSpace and Performance

Re: size of TableSpace and Performance

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 21 Jul 1999 21:32:52 +0800
Message-ID: <3795CC04.2CF8@yahoo.com>


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
--



Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Wed Jul 21 1999 - 08:32:52 CDT

Original text of this message

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