AIX, Oracle and concurrent I/O

[shortline]

Hello Tek-Tips,

AIX 5.2 ML05
Oracle 9.2.0.8

I am trying to implement cio on an Oracle CRM database.
The data, redo and temp filesystems are mounted with the cio option. the Oracle parameter filesystemio_option is set to setall

How can I determine if cio is being used properly?

I ran a truss on an Oracle process and saw the process open a file with O_DSYNC - if cio shouldn't it use the O_CIO flag to open files?

Using lsof +fg
oracle 23187544 oracle 8u VREG R,W,DSYN,LG,0x80;CX,BR 41,1 512003 4043309197 /crmdevldata1 (/dev/crmdevldata1lv)

Shows DSYN instead of CIO.

Any help is greatly appreciated!!!

 

[tempest92]

i am not in front of an aix machine at the moment but doesn't the mount command have an options column. so just entering 'mount' should show you what's mounted with what options.

 

[shortline]

Hi tempest92,

Yes mount shows the filesystems mounted with the cio options.

I would like to know how to verify Oracle is using cio properly.

Thank you