Database Tuning (MOSC)

MOSC Banner

Index reorganization runs slower with async IO

Hello,

We are running into performance issue where we could not understand the reason where we turned on async IO on by setting these two parameters:

disk_asynch_io=true

filesystemio_options=setall

Overall performance is much better especially in log writing except one process that does index reorganization that is 2-3 times slower.

Changed to filesystemio_options=async without direct IO and perrormance is almost back to orginal.

database server: 19.25

server: REHL 7

Based on some documents, direct IO should be more efficient, not the result is opposite.

Looking for suggestions on this issue.

Thanks

Larry

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center