I am using Oracle to build a data warehouse for an organization that has about 2 TB data at the moment, and most likely more in the future. I don't know how to manage storage for this system -- should I use SAN or NAS?
It really depends a lot on your requirements. If there is a need for a high transaction rate, you might want to implement a
and work with your vendor of choice for the management of the SAN. If the transaction rate requirement is more modest, you could install a
system and the administration would be much less than with a SAN. Make sure that whatever solution you choice, the management software has some visibility for the Oracle database.
Dig Deeper on Data storage strategy
Compare SAN and NAS, and find out what to consider when using each storage system format. Object storage and the cloud are also affecting the storage...
Logical unit numbers are a logical abstraction between a physical disk device and applications. Learn more about LUN use cases and LUN security ...
What is the one hidden gotcha that you'd advise users about if they were shopping for an all-flash storage array?