Bigfile tablespaces on OS filesystems?
- From: Lou Avrami <avramil@xxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 21 Sep 2009 13:44:57 -0400 (EDT)
Hello all,
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.
:-)
Thanks,
Lou Avrami
--
//www.freelists.org/webpage/oracle-l
Other related posts:
