This discussion is archived
2 Replies Latest reply: Oct 21, 2013 12:44 AM by oelk0 RSS

XE10 / 11: Asynchronous I/O

oelk0 Newbie
Currently Being Moderated

Hie everybody,

 

the 'Performance und Tuning Guide' describes:

FILESYSTEMIO_OPTIONS Initialization Parameter

Use asynchronous I/O when possible to avoid bottlenecks.

ASYNCH: enable asynchronous I/O on file system files,

        which has no timing requirement for transmission

 

I would use:

'filesystemio_options=asynch'

in the pfile/spfile.

 

Does this mean ext3 with option 'noatime' ?

 

Which file systems are supported in Linux ext2, ext3, ext4?

This time i'm using openSUSE 11.x and 12.x on SATA disks without LVM and ext4,

but i would like to change to Oralce Linux.

 

Best regards

  • 1. Re: XE10 / 11: Asynchronous I/O
    clcarter Expert
    Currently Being Moderated

    What's the goal? Seeking the magical "Go Fast" button?

     

    Unless specific performance goals are targeted, and method(s) to test and verify those goals are/are not being met the AIO bang might not even be noticable.

     

    Make one change, measure, and compare results. Not two, nor twenty, changes in host + instance parameters then go back and figure out which change broke, harmed, or improved performance in the tuning efforts.

  • 2. Re: XE10 / 11: Asynchronous I/O
    oelk0 Newbie
    Currently Being Moderated

    Hello clcarter,

     

    i don't looking for a "Go Fast" button.

     

    I only read the the 'Performance und Tuning Guide' and found the 'FILESYSTEMIO_OPTIONS Initialization Parameter'

     

    Best regards.

    Achim

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points