Poor performance after migration from 9.2.0.7 to 10.2.0.4 AIX 5.3L JFS2 CIO
AIX 5.3L
filesystem /oradata mount with option cio (concurent input/output)
Parameter filesystemio_optins in init.ora omited.
Oracle 9i 9.2.0.7 - good performance
Oracle 10g 10.2.0.4 - poor performance
In Oracle 9i&10gR1 on IBM AIX5L Tips&Considerations
http://www-03.ibm.com/support/techdocs/atsmastr.nsf/5cb5ed706d254a8186256c71006d2e0a/c82a72e602d0fc4b86256fc100683d73/$FILE/080930-9i-tips.pdf
read:
Oracle 9i:
filesystemio_options=asynch (by default) + JFS2(cio mount) = asynchronous,CIO
Oracle 10g:
filesystemio_options=asynch (by default) + JFS2(cio mount) = asynchronous,CIO
After setting filesystemio_options=setAll performance good.
Trace process by command OS truss:
Parameter filesystemio_optins in init.ora omited.
Oracle 9i 9.2.0.7 - good performance
Oracle 10g 10.2.0.4 - poor performance
In Oracle 9i&10gR1 on IBM AIX5L Tips&Considerations
http://www-03.ibm.com/support/techdocs/atsmastr.nsf/5cb5ed706d254a8186256c71006d2e0a/c82a72e602d0fc4b86256fc100683d73/$FILE/080930-9i-tips.pdf
read:
Oracle 9i:
filesystemio_options=asynch (by default) + JFS2(cio mount) = asynchronous,CIO
Oracle 10g:
filesystemio_options=asynch (by default) + JFS2(cio mount) = asynchronous,CIO
After setting filesystemio_options=setAll performance good.
Trace process by command OS truss:
0