2gb filesize, large disks and splitting tablespaces

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Tue, 5 Jun 2001 15:40:10 +0100
Message-ID: <991752033.16280.0.nnrp-10.c30bdde2@news.demon.co.uk>

A post I just saw of Niall's reminded me of something. I'm on Solaris7/Oracle 816 (Sparc) and remember the dire warnings in days of yore about unix 'largefiles', ie. files over 2gb in size.

ps. Volume Manager 3.0.4, VXFS 3.3.2

I know Solaris7 has support for them, and I (think I) know Oracle is fine with it, but in this combination? Yay? Nay? Eh? Horror stories? Success?

In fact, what is the current thinking these days regarding large disks? Reason I ask is at the moment, the array is populated with 4gb disks (!), but the new array coming is 18gb disks.

As an *example*: suppose I have an 18gb disk and at the moment, I have 3x2gb files making a 6gb tablespace. Assuming *just for the sake of argument* I had to put these on the one disk, would you still place them in 3 files on that disk or in one file?

Any advantages one way or the other d'ya think? Such a thing as 'datafile header contention'? Are the db_writer's more 'intelligent' with multiple files?

Discuss....

Andrew :o) Received on Tue Jun 05 2001 - 09:40:10 CDT