Wednesday, August 12, 2020
dbametrix
More
    Home Oracle DBA Tips Differences of Filesystems

    Differences of Filesystems

    Blog post provides basics of file systems. Differences of File systems for improving performance of databases.

    Difference between NAS,NFS, and SAN storage for Oracle Database.

    Network Attached Storage space is file level computer data storage space which is connected to a computer network of number of computers providing information access to different network computers. NAS is a convenient method of sharing Oracle files among multiple computers. It has many advantages over single Oracle file servers like faster data access, easier administration and simplicity in its configuration. It not only operates as a file server at a central location but also provides connectivity from different data centers. An Oracle database using network attached storage can be connected to local area network using a Ethernet hard drives (SATA, SAS, USB, Fiber channel).

    - Advertisement -
    dbametrix

    Oracle database using network attached storage allows more than one hard drive, often arranged into logical, redundant storage containers or RAID arrays. Thus it minimizes the task of file serving to the database from other servers over the network. It is highly proffered as an ERP database solution as it can be configured over the network, even using a browser. An Oracle database mounted on network attached storage provides a centralized storage to client computers in environments with large amounts of data. Oracle database over network attached storage can lower cost by load balancing.

    Network File System (NFS) is a network file system protocol, which allows a client computer to access files in a manner similar to local storage. The recent network file system (NFS) protocols enables data access parallelism, thus allowing an Oracle database to hold the names of files and their data under the single server. The network file system protocol can be implemented on many operating systems, making the Oracle database highly available at many platforms. NFS is often used with Unix operating systems, classic Mac OS, OpenVMS, Microsoft Windows, Novell NetWare, and IBM AS/400.

    An Oracle database using storage area network (SAN) is a network that is dedicated to the database and is accessible to a block level storage. A storage area network are used to make data storage devices accessible to servers, so that the storage unit appears like locally attached devices to the operating system. A database using storage area network has a network of storage devices that are not accessible through the local area network by other devices. The database using storage area network is not proffered for a business implementing an ERP. An oracle database using a storage area network would easily get corrupted because multiple systems were simply to attempt to share virtual hard drives. But of course a database, in which a transaction needs a high speed block level access should use storage area network.

    NAS provides both storage and a file system, but SAN supplies only block-based storage space and abscond file system apprehensions on the local manner. Theoretically, NAS emerges to the client operating system as a file server i.e. the client be able to attach network drives to splits on that server side, whereas a local disk obtainable through a SAN still become visible to the client operating system as a disk, visible in disk and volume management utilities (along with client’s local disks), and available to be formatted with a file system and mounted.

    - Advertisement -
    dbametrix

    This is basics of File systems and every Oracle DBA should need to keep in mind or aware of this knowledge. Without having this kind of knowledge, you never be an expert in database administration. Because when you are going to perform disk I/O tuning for decreasing read/write then you should be aware of this knowledge. You may be find out some more Oracle DBA Tutorials from our blog. This blog runs by Dbametrix.

    2+
    - Advertisement -
    dbametrix
    - Advertisment -
    dbametrix

    Most Popular

    ASM Disk creation issue

    The article explains how to troubleshoot Oracle ASM disk creation. Solution of Oracle ASM disk creation with ASMLIB

    Oracle Tuning Basics Part-2

    This is the 2nd part of Oracle database tuning basics including depth of every aspects.

    Oracle Tuning Basics Part-1

    The article explains Oracle database performance tuning basics details.

    When you finding new job

    The article guides you 10 things to remember when you are searching a new job to improve yourself including skills and better growth for every DBA.

    Recent Comments

    Gordon Coleclough on Oracle Tuning Basics Part-1
    Gordon Coleclough on ASM Disk creation issue