Database Administration (MOSC)

MOSC Banner

Poor performance after migration from 9.2.0.7 to 10.2.0.4 AIX 5.3L JFS2 CIO

edited Jan 14, 2009 5:33AM in Database Administration (MOSC) 1 commentAnswered
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:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center