Xref: alice comp.databases.oracle.server:72231 comp.databases.oracle.tools:34836
Path: alice!news-feed.fnsi.net!newsfeed.direct.ca!newsfeed.berkeley.edu!news-out.uswest.net!news.uswest.net!not-for-mail
Message-ID: <381C4ACE.9CF89D@uswest.net>
From: Chuck Kuhlman <ckuhlman@uswest.net>
Reply-To: ckuhlman@uswest.net
X-Mailer: Mozilla 4.6 [en] (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server,comp.databases.oracle.tools,comp.databases.oracle.Misc,comp.unix.aix
Subject: Re: Oracle On AIX :  Urgent Help Required
References: <381C0C1C.3D529B90@cableinet.co.uk>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 37
Date: Sun, 31 Oct 1999 07:57:34 -0600
X-Trace: news.uswest.net 941378536 216.160.19.74 (Sun, 31 Oct 1999 08:02:16 CST)
NNTP-Posting-Date: Sun, 31 Oct 1999 08:02:16 CST

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.