Re: 2gb filesize, large disks and splitting tablespaces

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: Tue, 05 Jun 2001 15:15:25 GMT
Message-ID: <3b1cf539.6141477@news-server>

On Tue, 5 Jun 2001 15:40:10 +0100, "andrew_webby at hotmail" <spam_at_no.thanks.com> wrote:

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

IIRC, there is something in Steve's site about this and more 2Gb files being better than less >2Gb files. Can't remember the details, you might have to go for a gander there.

Me? After being bitten many, many times with nasty undocumented bugs in just about every combination of OS and Oracle, if anyone asks me to create a file greater than 2Gb in ANY OS, I just shoot them on the spot. Problem solved.

Cheers
Nuno Souto
nsouto_at_bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Tue Jun 05 2001 - 10:15:25 CDT