DISK_ASYNCH_IO=TRUE, FILESYSTEMIO_OPTIONS=SETALL but v$iostat.file=ASYNC_OFF [message #684370] |
Fri, 21 May 2021 13:50 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/7de89799585208213a11decf070b3aa4?s=64&d=mm&r=g) |
burkinaone
Messages: 11 Registered: October 2020
|
Junior Member |
|
|
Hello.
DB is Oracle 19.3 on RHEL 7.9
ASM
I have this:
DISK_ASYNCH_IO=TRUE
FILESYSTEMIO_OPTIONS=SETALL
But when I run this query, I get ASYNC_OFF for all the rows:
SELECT d.name,
i.asynch_io
FROM v$datafile d,
v$iostat_file i
WHERE d.file# = i.file_no
AND i.filetype_name = 'Data File';
Trying to find out why.
Thanks for your responses.
|
|
|
|
|
|
|
|
|
|