AIX

Thanks! ibmtech,

Good catch! the client daemon was not started after increasing memory.

So, shall I mount it with cio option?

Ok,
AIX6.1 and AIX7.1 combined with oracle >= 11.2.0.2 introduced a new open flag O_CIOR which is same as O_CIO, but this allows subsequent open calls without CIO. The advantage of this enhancement is that other applications like cp, dd, cpio can access database files in read only mode without having to open them with CIO. Starting with oracle 11.2.0.2 when AIX6.1 or AIX7.1 is detected, Oracle will use O_CIOR option to open a file on JFS2. Therefore you should no longer mount the filesystems with mount option -o cio.


I can see you have AIX7.1 and 11gR2, so that should hold good.



I hope this helps.

You are great! thanks a lot! Appreciate it.
This was exactly I was looking for, I can now show it to DBA.
Thanks again.

As far as i know you need still set the following DB parameter:

Code:

To use CIO with JFS2 for Oracle 10g / 11g together with
ASYNC I/O operation, set the initialization parameter 
FILESYSTEMIO_OPTIONS=SETALL in the (s)pfile.

Regards

One person has to set that parameter and that person is DBA. He/She (DBA) will set FILESYSTEMIO_OPTIONS=SETALL parameter in init.ora file, they will have to bounce the database after setting that value.
Again, one can go with ASYNC or SETALL, depending on the type and size of DB.

Thanks for the valuable input guys.