Best Storage Architecture for Oracle Perf?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Best Storage Architecture for Oracle Perf?

  1. #1
    Join Date
    Apr 2000
    Location
    Charlotte, NC, USA
    Posts
    48

    Question

    We are evaluating storage expansion for our Oracle
    databases. I have been asked by my Unix SA what my
    preference is between the following.

    My gut tells me to select SAN, but I need some doco to
    back me up.

    Oracle best performance on:
    NAS - Network Attached Storage - I think this is bad
    NFS - NFSmounted - I think this could be even worse
    SAN - Storage ArrayNetwork - YES (like StorageTek,
    EMC, etc)

    I am looking for doco that supports the best decision
    and your opinion. We will soon have several instances
    up to 250 GIG, OLTP and DSS.

    Thanx for your time :)!

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095

    For maximum performance, I like to run my DBs on Hardware RAID Disk Arrays with 0+1 RAID.

    NAS - Basically, the same thing as a SAN except it runs over 100BT. I personally don't use them, but I know of several people who do for Oracle DBs.
    NFS - As long as your NFS Server is reliable (multi-node failover) you're probably OK. In theory, all that Oracle does is cache data and act like a pseudo-disk farm anyway.
    SAN - Depending on your site, may be overkill. Also, while the technology is coming along, it's not really 100% yet (IMHO)

    I like to buy disk arrays and tape librarys that are SAN compatible. For example, I buy components that I can create a SAN with one node. Each SAN is an island, they don't interconnect (Yet). That way, I have dedicated disk for each server, but I don't have to worry about security and SAN performance.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Actually, there is a good article at [url]http://swexpert.com/CB/SE.C11.JAN.01.pdf[/url]

    and also a good group of articles at:
    [url]http://search.cpg.com/query.html?col=&ht=0&qp=&qs=&qc=&pw=100%25&ws=0&la=&qm=1&si=0&rf=1&qm=1&ct=1826737674[/url]
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width