Re: solaris ufs and filesystemio_options with setall

On Thu, 12 Jul 2007 22:25:12 +0000, staind wrote:

> I have a quick question about direct i/o and the filesystemio_options
> parameter, in particular on ufs and Solaris. My understanding is that if
> we set this to setall (or directio), Oracle will, at its discretion, use
> direct i/o for file access.

O_DIRECT is an argument to the "open" system call. You should do truss -o /tmp/out -f sqlplus "/ as sysdba" (-f option will descend into the forked processes) and then start the database. If the data files are open with the O_DIRECT flag, you have direct I/O. Alternatively, you can use dtrace to trap the "open" system call and see the argument values (Solaris 10, only). I am more of a Linux guy, Solaris is not my forte.

-- 
http://www.mladen-gogala.com