File System Alternatives

If you decide to implement database files on file systems, you can choose from a number of alternative UFS-style implementations:

  • Standard UFS (as implemented by Solaris). All access to UFS pages is managed through the Solaris file system page cache. We considered the characteristics of UFS files in the previous section.

  • Direct I/O. As of Solaris 2.6, file systems can be mounted with the forcedirectio option. Disk accesses to files on such file systems will bypass the Solaris file system page cache. KAIO (Kernel Asynchronous I/O) is not used, however, when asynchronous I/Os are issued on Direct I/O-enabled files. If log files are not placed on raw devices, they should be placed on file systems mounted with Direct I/O ...

Get Configuring and Tuning Databases on the Solaris™ Platform now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.