Solved

CIO on best XFS options for Oracle with redhat

Posted on 2014-01-16
3
1,109 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 62

Expert Comment

by:gheist
ID: 39788974
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
ID: 39789115
I have  noatime.
  what is relatim?
0
 
LVL 62

Accepted Solution

by:
gheist earned 500 total points
ID: 39789208
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Installing FreeBSD… FreeBSD is a darling of an operating system. The stability and usability make it a clear choice for servers and desktops (for the cunning). Savvy?  The Ports collection makes available every popular FOSS application and packag…
Why Shell Scripting? Shell scripting is a powerful method of accessing UNIX systems and it is very flexible. Shell scripts are required when we want to execute a sequence of commands in Unix flavored operating systems. “Shell” is the command line i…
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…

738 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