RE: Excessive Paging - AIX Related?

From: <cjgait_at_earthlink.net>
Date: Mon, 07 Jan 2002 07:34:01 -0800
Message-ID: <F001.003E85A5.20020107071043@fatcity.com>

Ethan,

There is an excellent section on AIX specific tuning in Oracle Performance Tuning 101 (ISBN 007213145-4).

I ran into a similar paging problem on a client's machine and the IBM tech (who was there a day before me) had already fixed the main 'Oracle' performance problem I was coming in to tune. It was in fact just a matter of getting the right mix of minperm and maxperm in vmtune on the OS. The default values are 80/20, which stinks. Ask IBM to give you more reasonable figures and buy Gaja's (et al.) book.

Regards,
Chris Gait
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: cjgait_at_earthlink.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Jan 07 2002 - 09:34:01 CST