oracle database with san

[Jason Myres]

Here in videoland our focus is generally on bandwidth, but as a DBA you’ll be more interested in I/O performance. You might find that in a SAN, a highly optimized NAS, or even a combination of the two. I would take a look at how an array like this works, and then work out from there:

https://www.oracle.com/us/products/servers-storage/storage/disk-storage/043967.html

Here is a good article you can take a look at as well:

https://www.dba-oracle.com/disk_i_o_speed_comparison.htm

JM

[Chris Gordon]

I assume that by “SAN” you mean the entire storage system, not just the Fibre Channel network used to connect the server and storage. I also assume that you run your databases on large enterprise class storage — EMC, NetApp, Hitachi, etc. In that case, look at the various storage vendor’s training programs or work with the storage admins at your current place of employment and see if you could work with/for them as an apprentice and learn that way. Different arrays from different vendors (even arrays from the same vendor) are very different and take some specialized training (formal or informal) to learn. It’s not unlike a database Just because you may be an expert on Oracle doesn’t mean you’re an expert on every database that exists. This is probably at least a 1 – 2 year endeavor.