Re: Oracle On AIX : Urgent Help Required

Where to start...

There aren't too many AIX related tuning parameters to check.

Here are a few:

paging space.

aio (async I/O) configuration.

hot drives (I hope you're using mirrored drive sets, striped+mirrored on ssa will give great performance, far better than any scsi).

hot ssa adapters (NO MORE than 32 drives per adapter if you want to approach the best possible performance). Again, spread the workload out.

ssa adapter placement. Don't jam all of your ssa adapters onto one side of the microchannel.

network adapter tuning (lsattr -El entX).

IP stack tuning (no -a parameters).

check vmtune to make sure you're not starving the kernel or the sga for real memory.

how big is your sga? if it's too big, there is a possibility that the sga itself could be swapped out.

If you hire in a competent AIX specialist for a day or two, that person should be able to take care of the basic and middle difficulty AIX-RS/0000 tuning issues without more than 1-2 reboots (some tuning settings are activated at boot time only).

Purely disk related tuning issues may require that you rethink/redo your table space to disk drive relationships. Received on Sun Oct 31 1999 - 07:57:34 CST