Concurrent IO and Direct IO?
we have upgraded a lot of databases to 9.5.2. I have some questions regarding CIO and DIO.
It seems, that there a two ways of activating this feature. I can turn off Filesystem caching on tablespace level and then the database is using CIO or DIO in dependency of the filesystem.
Alternative I can change the mount points on unix level and mount using DIO or CIO.
Is this so far correct?
We have for some databases deactivated the filesystem caching on tablespace level with alter tablespace.... for all DMS. What about SMS? In one documentation I have read for 8.2.2 that for SMS/DMS temporary tablespaces the filesystem caching shouldn't been deactivated. Is this still valid for 9.5.2?