Dear list, As promised, I have summarized the issues that folks on this list are dealing with, when deploying Oracle in a SAN/NAS enviroment. I really appreciate the time that you took to respond to my questions. Thanks to everyone who responded.
Issues: ------ 1) Lack of performance consistency in multiple volume groups. For example, if there are 2 volume groups v1 and v2 and they both are 4-way striped and mirrored, v1 should not outperform v2 in any way shape or form. 2) Volume Groups that require “rebuilds” during extension (growth). 3) Lack of simplicity in what the DBA needs to interface. Too many components...require just “mount points” or directories to put stuff. 4) Lack of storage throughput capacity planning (IOPS, Transfer rate) in the volume groups, regardless of “h/w cache” present. 5) Lack of functionality that proactively eliminates (prevents) single point of failures. 6) Lack of “logical-to-physical” mapping of volumes. Need to know whether multiple logical volumes are sharing the same physical disks. 7) Lack of Oracle performance data correlation through the various layers of a SAN. 8) Lack of automation in filesystem placement and management. Ideally, it should be done based on I/O consumption and data criticality. 9) Lack of segregating NAS traffic from regular LAN traffic (underlying problem – single LAN segment). 10) Not considering REDO and UNDO as “corporate data” and NOT placing them in a SAN. 11) Lack of ease in administration functions such as adding new “mount points” in a SAN. 12) Lack of automation of backups in a SAN environment. 13) Lack of proactive detection of “configuration issues” such as dynamic multi path (DMP) and the impact of that on controller/fibre-card utilization. 14) Not recommending the amount of zoning that is required for a given environment. Cheers, Gaja ===== Gaja Krishna Vaidyanatha Principal Technical Product Manager, Application Performance Management, Veritas Corporation E-mail : [EMAIL PROTECTED] Phone: (650)-527-3180 Website: http://www.veritas.com __________________________________ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gaja Krishna Vaidyanatha INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
