Solved

CIO on best XFS options for Oracle with redhat

Posted on 2014-01-16
3
995 Views
Last Modified: 2014-01-22
we have seen too many issues with ext4 and redhat 6.5.after switching to XFS the database is performing at its best..
Now we need to make sure that we are getting the best out of XFS for redhat
how can we do that?

Also how can we determine if we have CIO running with our redhat 6.5 oracle 11g and XFS file system?

mount options

/dev/mapper/oracle_scripts_vg-oracle_scripts_lv on /u002 type xfs (rw,noatime,nobarrier,inode64,logbsize=256k)
/dev/mapper/oracle_data_vg-oracle_data_lv on /u003 type xfs (rw,noatime,nobarrier,inode64,logbsize=256k)
/dev/mapper/oracle_arch_redo_vg-oracle_arch_redo_lv on /u004 type xfs (rw,noatime,nobarrier,inode64,logbsize=256kg)
/dev/mapper/oracle_redo1_vg-oracle_redo1_lv on /u005 type xfs (rw,noatime,nobarrier,inode64,logbsize=256kg)
/dev/mapper/oracle_rman1_vg-oracle_rman1_lv on /u010 type xfs (rw,noatime,nobarrier,inode64,logbsize=256kg)
/dev/mapper/oracle_redo2_vg-oracle_redo2_lv on /u015 type xfs (rw,noatime,nobarrier,inode64,logbsize=256kg)
0
Comment
Question by:it-rex
  • 2
3 Comments
 
LVL 61

Expert Comment

by:gheist
Comment Utility
You need to try all FILESYSTEMIO_OPTIONS

    ASYNCH -> aio api that leaves write request and gets signal when that is done, makes good use of NCQ
    DIRECTIO -> skips journal
    SETALL -> both
    NONE -> neither

Also noatime/relatim mount options help a lot, as you already have set it up
0
 
LVL 11

Author Comment

by:it-rex
Comment Utility
I have  noatime.
  what is relatim?
0
 
LVL 61

Accepted Solution

by:
gheist earned 500 total points
Comment Utility
relatime is haldfof noatime, that makes mail and news work (not needed for oracle, you have the best option selected)

Also you might want to try Oracle Enterprise Linux UEK kernel, it has much newer kernel and xfs code.
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Unix / Linux grid computing 5 125
Sed question 2 45
Python Assistance 7 30
Searching File Names and Eliminating Duplicates in Linux 4 33
My previous tech tip, Installing the Solaris OS From the Flash Archive On a Tape (http://www.experts-exchange.com/articles/OS/Unix/Solaris/Installing-the-Solaris-OS-From-the-Flash-Archive-on-a-Tape.html), discussed installing the Solaris Operating S…
Using libpcap/Jpcap to capture and send packets on Solaris version (10/11) Library used: 1.      Libpcap (http://www.tcpdump.org) Version 1.2 2.      Jpcap(http://netresearch.ics.uci.edu/kfujii/Jpcap/doc/index.html) Version 0.6 Prerequisite: 1.      GCC …
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now