Shulou(Shulou.com)05/31 Report--

This article is to share with you about the filesystemio_options parameters in oracle asynchronous IO. The editor thinks it is very practical, so I share it with you. I hope you can get something after reading this article. Let's take a look at it.

Asynchronous Iripple O means that you can read and write at the same time.

Alter system set filesystemio_options=setall scope=spfile

Go to the linux system and check the asynchronous IO.

Grep kio / proc/slabinfo.

You can see that kiocb already has a data value, which means that asynchronous IO is already in effect.

Alter system set filesystemio_options= (none/setall/directIO/asynch)

ASYNCH: enable asynchronous I/O on file system files, which has no timing requirement for transmission.

Enable asynchronous Ihop O on file system files, and there is no timing requirement for data transfer.

DIRECTIO: enable direct I/O on file system files, which bypasses the buffer cache.

Enable direct buffer cache O on the file system file, bypassing it.

SETALL: enable both asynchronous and direct I/O on file system files.

Enable async and direct Igamo on file system files.

NONE: disable both asynchronous and direct I/O on file system files.

Disables async and direct Igamo on file system files.

These are the filesystemio_options parameters in oracle asynchronous IO. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.