Originally posted by: SarfarazSyed

Hello All,

I am running AIX7.1 TL01 SP 06 and oracle 11gR2. Things were running fine, until a few days ago application team started to complain about the response time.

Our DBA team (an outsource company), is recommending we create large_pages (tune lgpg_size and lgpg_regions) and remount oracle file systems as CIO.

For CIO, I have to recreate redo logs with 512b block size and I can use the other oracle file systems as default 4kb block size.

I have worked in other shops and I don't remember doing both, reading a lot of AIX documentation suggest go with Large_pages for oracle.

I have asked my peers working at big shot companies. But, they too claim, they have NOT setup any large_pages.

I would appreciate if you can shed some light on this and suggest a best way around.

I have done the math and lgpg_regions are coming to 256 (using "number_of_large_pages = INT [(SGA size - 1) / 16 MB)] + 1").

Thanks in advance!

Originally posted by: hdkutz

Hello,

I would recommend to take a look intoi

http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/WP100883

There is a chapter w´hich deals with you topic.

Cheers,

ku

Originally posted by: SarfarazSyed

Thanks Ku!

I found the answer, starting with oracle 11.2.0.2 on AIX6.1 and AIX7.1, we don't have to mount file systems with -o cio option. Setting the FILESYSTEMIO_OPTIONS on oracle will do it.