I am just going through resize a few database objects and came across some large datafiles and it reminded me about a thread on here about datafile sizes, but I can't remember the content of that thread..
Is a 10 gig datafile on a Sun Solaris machine too big ? If it is too big, why ? and if I should change it, how big should I create the datafiles.
If the OS is 64 bit and you have enabled the large file option at the OS level, then it's ok to have a large dbf. Else it is recommended that it not be more than 2047M. My OS is 32 bit w/o the large file option and I do not let the size of any file exceed 1995M. With a 64 bit OS and large file option, you can have a file as large as 1 terabyte.
Halo, thanks for that, it's pretty much what I thought.
Marist, I was going to go through the structure of the datafiles, but I probably just have to say that the machine only has 5 physical disks, a system disk and 4 Oracle disks. If you have so few disks, is it still better to split the datafiles on the same physical disk ? would that help IO contention ?