strace dbwr to confirm O_DIRECT on Redhat Linux
Date: Tue, 24 Mar 2009 09:37:50 +0000 (GMT)
I am trying to strace the dbwr process to confirm that oracle is using direct IO on 10g R2 non RAC RHEL 4.0
grep on the trace file does not show O_DIRECT this server uses LVM .
Command used was
strace -o /tmp/dbwr.out -p <<pid of dbwr>> &
and then opened a sqlplus session to to a
create test as
select * from big_table
i dont see any O_DIRECT in the dbwr.out file. filesystem options has been set to all in spfile.
Is there anything special that needs to be done in the LVM mount this is using ext3 as the filesystem