Bigfile tablespaces on OS filesystems?
Date: Mon, 21 Sep 2009 13:44:57 -0400 (EDT)
I have an INTERESTING scenario that I would like to run by you folks.
I have been assigned the task of migrating an existing data warehouse of approximately 2 TB to a new server running 11gR1. After much discussion ... the UNIX/SAN team will not OK using ASM, so I am stuck with creating tablespaces on OS filesystems.
Originally, I wanted to use bigfile tablespaces for the larger tablespaces, in conjunction with ASM. Now that ASM is out the window (at least for the moment - maybe we will be allowed to migrate to it someday), does it still make sense to use bigfile tablespaces?
The OS that the new data warehouse will be on is HP-UX 11.23, so I believe that means no asynch I/O at the filesystem level.
What would the read/write performance be like for something like a 500 GB bigfile tablespace on a UNIX OS filesystem? My initial impression is that concurrent reads and writes would have horrible performance, because UNIX would "force" the entire 500 GB file to be accessed for each read/write operation.
From a read/write performance perspective, would it be better to use smallfile tablespaces with multiple uniform datafiles?
Any helpful information would be much appreciate down here in the rabbit hole. :-)