Re: Question about tablespace datafile setup

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 20 Jan 2000 19:25:22 +0800
Message-ID: <3886F0A2.3FE7@yahoo.com>

John Matzen wrote:
>
> I'm going to be running Oracle 8i on Solaris 7 (Intel). I'll have a 30GB
> filesystem for data. Should I create several small datafiles (i.e. 2GB
> each?), one big file, a raw device (it's RAID-5), or an autoexpanding
> datafile?
>
> Thanks!
>
> John Matzen

I dunno if Solaris 7 fixed this, but asynch IO used to only work for files up to 2G on 2.6 and below.

Raw is probably fastest.

HTH
--

---

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 Thu Jan 20 2000 - 05:25:22 CST